topic Re: Counting records in QlikView

Counting records

Mon, 09 Mar 2015 19:44:17 GMT

I have a set of records a user has selected. I want to take the field due date and count how many records in the current set will happen in 90 days, 60 days, 30 days, and are past due.

Thanks

~Norman Rea

Re: Counting records

maxgro — Mon, 09 Mar 2015 19:56:54 GMT

if I understand,

with a calculated dimension

=if(duedate<=Today(), 'past due', class(duedate-Today(),30) )

and count(duedate) as expression

Re: Counting records

Mon, 09 Mar 2015 20:39:56 GMT

How would this work in a chart not a table. I have a gauge I am using to display.

Re: Counting records

Tue, 10 Mar 2015 13:38:17 GMT

Here is a image of what I am working with

Re: Counting records

maxgro — Tue, 10 Mar 2015 15:01:18 GMT

stacked horizontal bar chart,

no dimension

4 expression

=count(if(duedate<=Today(), duedate))

=count(if(duedate>=Today() and duedate<(today()+30), duedate))

...

also with set analysis instead of if