# 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
Did you mean:
Highlighted
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

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
3 Replies
Highlighted
Master II

## Re: Count of days calculation

Try something like below:

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

## Re: Count of days calculation

Hi,

You can create flag in your script like-