Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hello,
what's about Johan's solution: straight table with F1 as Dimension and Count(F1) as expression
Orlando
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.
Yes, the straight table does exactly what I'm looking for. Thank you very much.
Stefan