topic Re: Count IF in QlikView (Number of Days) in Water Cooler

Count IF in QlikView (Number of Days)

Mon, 26 Aug 2013 13:29:57 GMT

Hi All,

I'm trying to get the number of days per each name.. i can do it in excel but its hard for me to do it in QV.. can someone help me on this?

i attached my spreadsheet/QV sample and below should be the output..

Thanks

Re: Count IF in QlikView (Number of Days)

tresB — Mon, 26 Aug 2013 13:39:45 GMT

Your expression should be similar to this:

count(if((Today()-[Request Received])<=5, [Request Received]))

Re: Count IF in QlikView (Number of Days)

Mon, 26 Aug 2013 13:47:07 GMT

Hi Mildred,

Take a look at the attached file. I modify your expressions with set analysis for filtering datas.

For example :

=count({$<[Request Received] = {">=$(=Date(Today()-5))"}>} DISTINCT [Request Received])

In this expression, the part [Request Received] = {">=$(=Date(Today()-5))"} will filter the datas on field [Request Received] where the value is >= today - 5 days

Hope it helps.

Regards,

Nicolas

Re: Count IF in QlikView (Number of Days)

Mon, 26 Aug 2013 13:51:31 GMT

Thanks for the reply but i tried your codes and the total is still not correct..

the data in the spreadsheet is the correct one but in my QV sample i dont know the exact expression for that.

the total should be like this.. see below

Name	0-5 Days	6-10 Days	more than 10 Days	Total
Name A	1	1	26	28
Name B	3	4	24	31
Name C	1	1	11	13
Name D	4	5	44	53
Name E	2	3	28	33
Name F	2	4	27	33
Name G	4	5	43	52
Name H	4	5	50	59
Name I	4	5	42	51

Re: Count IF in QlikView (Number of Days)

rajeshvaswani77 — Mon, 26 Aug 2013 13:52:33 GMT

Hi Mildred,

Please find the attached solution.

regards,

Rajesh Vaswani

Re: Count IF in QlikView (Number of Days)

Mon, 26 Aug 2013 14:12:18 GMT

Thanks a lot Nicolas!