Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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..

Output.JPG.jpg

Thanks

1 Solution

Accepted Solutions
Not applicable
Author

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

View solution in original post

5 Replies
tresesco
MVP
MVP

Your expression should be similar to this:

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

Not applicable
Author

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

Not applicable
Author

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

Name0-5 Days6-10 Daysmore than 10 DaysTotal
Name A112628
Name B342431
Name C111113
Name D454453
Name E232833
Name F242733
Name G454352
Name H455059
Name I454251
rajeshvaswani77
Specialist III
Specialist III

Hi Mildred,

Please find the attached solution.

regards,

Rajesh Vaswani

Not applicable
Author

Thanks a lot Nicolas!