Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

Count of days calculation

Hi All,

I am calculating count of claim number based on category as well difference of date that is  like

No Of Unique Claims  with status code 'O' and difference between today and received date Greater than 30

No Of Unique Claims  with status code 'O' and difference between Edt date and received data Greater than 14

can some one please help me how i implement above date condition in my expression

1 Solution

Accepted Solutions
Highlighted

Re: Count of days calculation

The interval() is redundant in this expression - this is just a formatting statement so does nothing here:

Count(Distinct If(Today() - [received date],'D') > 30, Claims))

or

Count({<[received date] = {"<=$(=Date(Today() - 30))"}>} Distinct Claims)


Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

View solution in original post

3 Replies
Highlighted
Master II
Master II

Re: Count of days calculation

Try something like below:

Count(Distinct if(interval(today-received date,'D') > 30,Claims)

Highlighted

Re: Count of days calculation

The interval() is redundant in this expression - this is just a formatting statement so does nothing here:

Count(Distinct If(Today() - [received date],'D') > 30, Claims))

or

Count({<[received date] = {"<=$(=Date(Today() - 30))"}>} Distinct Claims)


Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

View solution in original post

Highlighted
Specialist
Specialist

Re: Count of days calculation

Hi,

You can create flag in your script like-

today()-received date>30, 1,0 as flag


same will be for Edt date -received data > 14 as flag2


and pass this flag in your expression-

Count({<flag={'1'}, status code={'O' }>}Claims)


Thanks,

Neha