Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

counting rows

Hello,

newbie question. I try to count the selected entries of a table. I have a script

LOAD * INLINE [
F1,F2
A,1
B,2
B,3
C,4
C,5
C,6
];

And there's a table box with F1 and F2. Now I want to have another table box to show the number of rows in the first table. The result should be 6 for no selection, 1 for A selected, 2 for B and 3 for C. I know there are count functions but I don't know how to apply them because I don't know how to refer a table.

Can you please help me? Thank you.

Stefan

12 Replies
orlando
Partner - Contributor
Partner - Contributor

Hello,

what's about Johan's solution: straight table with F1 as Dimension and Count(F1) as expression

Orlando

johnw
Champion III
Champion III

The Presidents demo, unless I misunderstood your question, is FAR different and more complicated than what you're looking for. As has been said, straight table, F1 as dimension, count(F1) as expression.

Not applicable
Author

Yes, the straight table does exactly what I'm looking for. Thank you very much. Smile

Stefan