topic Re. :counting rows in QlikView

counting rows

Thu, 12 Aug 2010 09:20:06 GMT

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

Re. :counting rows

martin59 — Thu, 12 Aug 2010 09:29:57 GMT

Hi,

If I were you, I would count the selected entries into my application, but not in script.

To do that, you have to create a chart with F1 as dimension, and the following expression :

Count(Distinct F2)

Re. :counting rows

Thu, 12 Aug 2010 10:34:38 GMT

Thank you very much. Not quite what I was looking for, but you showed me the way to count in the application. I'm a little more familiar with the object dialog windows now.

Re. :counting rows

Thu, 12 Aug 2010 11:40:36 GMT

If you want to show only the count, you can also create a text object with expression '=count(F1)' and display the result.

Re. :counting rows

Thu, 12 Aug 2010 13:14:01 GMT

Not bad. I also tried a statistics box which brings the best result so far because it has the right size and contains a text plus the count.

What would be best is a table box containing only one row with two columns. The left cell has a text constant, the right box has the count. But I don't see a way to put a formula into a table cell. Any idea?

Re. :counting rows

kji — Thu, 12 Aug 2010 13:16:19 GMT

Straight table (form of chart) is probably what you are looking for.

Re. :counting rows

Thu, 12 Aug 2010 13:54:53 GMT

Do you know the Presidents demo? In the tab "Presidents" there is a table on the left titles "Party". What kind of object is it and how did they manage to show the number of each party for the present selection?

counting rows

orlando — Thu, 12 Aug 2010 15:16:07 GMT

Perhpaps this helps:

//Text Box with:

=If(IsNull(GetFieldselections(F1)),'No. of F1 values',GetFieldselections(F1)) & ': ' &count( F1)

counting rows

Thu, 12 Aug 2010 15:27:02 GMT

Definitely a cool piece of code. It's just not table style.

counting rows

Thu, 12 Aug 2010 15:36:25 GMT

I'd like to have a table with two columns

F1 -> count(F1)

Selecting A would result in a table

A | 1

Selecting B and C results in

B | 2

C | 3

I think the Presidents demo does the trick with the statistics box but I'm not sure.

counting rows

orlando — Thu, 12 Aug 2010 15:58:18 GMT

Hello,

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

Orlando

counting rows

johnw — Thu, 12 Aug 2010 19:49:39 GMT

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.

counting rows

Fri, 13 Aug 2010 08:18:36 GMT

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

Stefan