Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Skywalker
Contributor
Contributor

Count based on 30, 60 and 90 Days

Hello Expers, 

I am trying to draw a chart based on days remaining. Group them in 30, 60, 90 and others. 

Username   Expiry Date 

Test                 MM/DD/YYYY

Its something simple but I am not able to put it together at the moment. 

 

Thank you. 

 

Labels (2)
4 Replies
vikasmahajan

You can do this by creating four expressions/measures

0-30 day bucket
sum({<[Expiry Date ]={">$(=today()-30)<=$(=today())"}>}[ your Measure Field]) 

60 day bucket
sum({<[Expiry Date ]={">$(=today()-60)<=$(=today()-30)"}>}[ your Measure Field]) 

90 day bucket
sum({<[Expiry Date ]={">$(=today()-90)<=$(=today()-60)"}>}[ your Measure Field]) 

Hope this help you

Thanks

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.
Skywalker
Contributor
Contributor
Author

Hi Vikas,

Thank you for helping out, I tried to add the expression but did not work, I might not be doing it right, I have a list of User name, who expires on different dates but I want to graph a bar chart showing how many will expire in coming 30 days, 60 and 90. Just the number. The graph has Dimension and measure, what can I put in Dims? 

sum({<[Expiry Date ]={">$(=today()-30)<=$(=today())"}>}[ your Measure Field]) 

Thank you. 

 

vikasmahajan

You need  user Name  wise report right ? then user name will be dimension & keep all expressions in measures 

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.
Skywalker
Contributor
Contributor
Author

Hi Vikas,

I need username - count based report, like 

100 - expire in less then or equal to  30 days, 

50 - in 60

200 in 90 days. 

 

Thank you,