Qlik Community

Qlik Community Help Discussions

Discussion board for questions on how to use Qlik Community and its features.

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

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

5 Replies
MVP
MVP

Re: Count IF in QlikView (Number of Days)

Your expression should be similar to this:

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

Not applicable

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

Not applicable

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

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
Valued Contributor III

Re: Count IF in QlikView (Number of Days)

Hi Mildred,

Please find the attached solution.

regards,

Rajesh Vaswani

Not applicable

Re: Count IF in QlikView (Number of Days)

Thanks a lot Nicolas!