Count IF in QlikView (Number of Days)

[#1]

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

[tresesco]

Your expression should be similar to this:

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

[#3 · Accepted solution]

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

[#4]

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

[rajeshvaswani77]

Hi Mildred,

Please find the attached solution.

regards,

Rajesh Vaswani

[#6]

Thanks a lot Nicolas!