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: 
LordGrim
Contributor III
Contributor III

KPI - show count for last 30 days

Hi,

Simple thing.

I have a KPI from charts and just want to show the total count of 'Date Created' for the last 30 days and then another the count on the previous 30 days.

I have this at the moment: 
Count({<[Date Created]*={'11/02/2020'}>}[Date Created]) But this only shows for the one date.
Any direction on this gratefully accepted.

Thanks

Labels (1)
11 Replies
sunny_talwar

Try this

Count({<[Date Created] *= {">=$(=Date(Today(1) - 30, 'DD/MM/YYYY'))<=$(=Date(Today(1), 'DD/MM/YYYY'))"}>} [Date Created])

I missed closing parenthesis when I posted this expression above. You can see the evaluation of your set analysis right underneath

image.png

 

LordGrim
Contributor III
Contributor III
Author

Thats done it! - thanks very much for your help and patience.