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: 
chaitanyajami
Partner - Creator
Partner - Creator

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
jonathandienst
Partner - Champion III
Partner - Champion III

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
sushil353
Master II
Master II

Try something like below:

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

jonathandienst
Partner - Champion III
Partner - Champion III

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
neha_shirsath
Specialist
Specialist

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