topic Re: Count With No Dimension in QlikView

Count With No Dimension

Anonymous — Fri, 12 Jul 2013 18:29:17 GMT

Conside a table with fields:

ClientName VoteDate Rank

I need to do a Count on ClinetName with Rank=1 for example, but the issue is the Dimension, cannot do it with VoteDate field. I need to show the Count (of ClientName where Rank=1) on any current date. Client may have a VoteDate of last year or this quarter, both should be counted as long as they are ranked 1 and then plot this Count on a line chart.

Secondly, when a Quarter ends, I need to take a snapshot of the count at that time and save it to a static Excel file that already contains two columns i.e. Quarter and Count. Both fields from this static file are plotted on a line chart (mentioned above) and current Quaretr Count (that I'm trying to calculate dynamically) should be appeneded to that chart.

Would much appreciate any ideas or solutions.

Re: Count With No Dimension

swuehl — Fri, 12 Jul 2013 18:52:35 GMT

So your dimension is VoteDate, but you want to ignore the dimension when evaluating your count?

Maybe like

=count({<Rank = {1}>} TOTAL ClientName)

Re: Count With No Dimension

Anonymous — Fri, 12 Jul 2013 19:48:16 GMT

This expression gives me correct total but when try to show in a chart, the number repeats for every date value i have. Need to show just one row with current quarter value in the dimension.

Re: Count With No Dimension

swuehl — Fri, 12 Jul 2013 23:48:49 GMT

Hm, not sure if I understand, but maybe something like this assuming your dimension is VoteDate

=if(VoteDate = max(TOTAL VoteDate), count({<Rank = {1}>} TOTAL ClientName)

and check 'suppress zero values' in presentation tab.