I.T. Discussion Community!
-Collapse +Expand
Paradox
Search Paradox Group:

Advanced
-Collapse +Expand Paradox To/From
To/FromCODEGuides
-Collapse +Expand Paradox Store
PRESTWOODSTORE

Prestwood eMagazine

August Edition
Subscribe now! It's Free!
Enter your email:

   ► MB LobbyCorel Paradox / ObjectPAL Coding BoardParadox Graphs & Charts Topic   Print This     

Queries to Charts

Queries to Charts in Paradox Graphs & Charts topic (part of our Corel Paradox / ObjectPAL Coding group).

Quick Search: Queries   Queries Charts  
rt
Castel, -- UK
Since Paradox covers so much there are times when total memory failure appears to set in and I have to ask what are sometimes seemingly simple questions.. well, I'm honest and if you never ask you never learn!

So, we have a table with a numerical key reference field and 5 other fields containing nothing except 'Yes' or 'No' data without any naughty odd blank records.
What is required is the dreaded chart (are you smiling yet AI?) to show a total count of how many Yes's there are in each field and to make a comparison with the total number of records which can be obtained from the reference field.
I hope this isn't too embarassing!.rt

Thats enough of that. Ed.

 Posted 18 years ago (Thread Starter)
Comment Quote
About rt -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.
About rt

I do like my jazz and blues!


Post ID #1857, 4 replies
Thread Started 4/26/2001 1:04:00 PM
View Counter=1644
Last Reply Posted 5/5/2001 5:47:00 AM)
Location=Castel, -- UK 
Joined=19 years ago   MB Posts=687   KB Comments=1  
rt
Castel, -- UK
Thank you, very clever! I must say I had tried most things except getting the first field (Seq) to effectively count itself and you also did the extra bit by counting both Yes's and No's.

By all means give yourself a house-mark, but dare I say that you did make a tiny error (yes, whoops even you AI!) in that you enclosed the word Index in "" which, whilst the QBE works ok, it don't not work as regrds making an Index field for the chart.

We really ought to do a 'piece' on queries - I'll produce the akward questions and you produce the answers...
Thanks. rt Big Grin!

Thats enough of that. Ed.

 Posted 18 years ago (Thread Starter)
Comment Quote
About rt -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.
About rt

I do like my jazz and blues!


Post ID #1875 (Level 1.1)  Reply to 1857
Thread Started 4/27/2001 12:38:00 PM
View Counter=2
Location=Castel, -- UK 
Joined=19 years ago   MB Posts=687   KB Comments=1  
Most Recent Post
rt
Castel, -- UK
Agreed.
But, even with my failing memory cells I know not "Index field for the chart" (sic) of which you quote - from whence did you get it?
rt

Thats enough of that. Ed.

 Posted 18 years ago (Thread Starter)
Comment Quote
About rt -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.
About rt

I do like my jazz and blues!


Post ID #2015 (Level 1.2)  Reply to 1857
Reply Posted 5/5/2001 5:47:00 AM
Location=Castel, -- UK 
Joined=19 years ago   MB Posts=687   KB Comments=1  
AIBreveleri
No, really, I'm not embarrassed at all.

You didn't give a table structure so I made one up.

------| rtprob31.db
+ * Seq
A1 AreYouReally
A1 DoesSheEver
A1 WillISomeday
A1 HasItByNow
A1 CanYouBelieve


...five yes/no questions, as you can see. The folllowing query, should you choose to accept it, will produce a table suitable for charting as a 2D summary:

Query
ANSWER: :PRIV:__rtpr31.DB
OPTIONS: NO AUXILIARY TABLES
rtprob31.db | Seq |
| calc count all as "Seq", calc "Really I Am" as "Index" |
| calc count all as "Seq", calc "Certainly Not!" as "Index" |
| calc count all as "Seq", calc "Sometimes She Does" as "Index" |
| calc count all as "Seq", calc "Never, She Says" as "Index" |
| calc count all as "Seq", calc "Someday You Will" as "Index" |
| calc count all as "Seq", calc "In Your Dreams Boyo" as "Index" |
| calc count all as "Seq", calc "It Must Have Done" as "Index" |
| calc count all as "Seq", calc "It Has Not Yet" as "Index" |
| calc count all as "Seq", calc "I Can Believe It" as "Index" |
| calc count all as "Seq", calc "Stop Having Me On" as "Index" |

rtprob31.db | AreYouReally | DoesSheEver | WillISomeday | HasItByNow | CanYouBelieve |
| "Y" | | | | |
| "N" | | | | |
| | "Y" | | | |
| | "N" | | | |
| | | "Y" | | |
| | | "N" | | |
| | | | "Y" | |
| | | | "N" | |
| | | | | "Y" |
| | | | | "N" |

EndQuery


Also watch your e-inbox for a zip file with sample table, this qbe, and chart form. Good luck and keep charting!

-Al.
 Posted 18 years ago
Comment Quote
About AIBreveleri -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.

Post ID #1874 (Level 1.3)  Reply to 1857
Reply Posted 4/27/2001 9:40:00 AM
Location= 
Joined=18 years ago   MB Posts=286   KB Comments=8  
AIBreveleri
The intent is to create an answer table with two columns, 'Seq' and 'Index'. The data would be charted as a 2D summary grouped on 'Index' and reifying the values in 'Seq'. QBE queries never produce indexed answer sets. I know not this 'Index field for the chart' of which you speak.

-Al.
 Posted 18 years ago
Comment Quote
About AIBreveleri -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.

Post ID #2003 (Level 1.4)  Reply to 1857
Reply Posted 5/4/2001 9:09:00 AM
Location= 
Joined=18 years ago   MB Posts=286   KB Comments=8  

Revive Thread!

Add a comment to revive this old thread and make this archived thread more useful.

Write a Comment...
Full Editor
...
Sign in...

If you are a member, Sign In. Or, you can Create a Free account now.


Anonymous Post (text-only, no HTML):

Enter your name and security key.

Your Name:
Security key = P1251A1
Enter key:
Icon: A Post    Thread    Idea    Important!    Cool    Sad    No    Yes    Includes a Link...   
Thread #1857 Counter
1644
Since 4/2/2008
Follow PrestwoodBoards on: 


©1995-2019 PrestwoodBoards  [Security & Privacy]
Professional IT Services: Coding | Websites | Computer Tech