5 Replies Latest reply: Aug 26, 2013 10:12 AM by Mildred Moral

Count IF in QlikView (Number of Days)

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)

Your expression should be similar to this:

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

• Re: Count IF in QlikView (Number of Days)

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)

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)

Thanks a lot Nicolas!

• Re: Count IF in QlikView (Number of Days)

Hi Mildred,

Please find the attached solution.

regards,

Rajesh Vaswani