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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
tvisha
Creator II
Creator II

Limit data in graph for last 30 days

hi,

 

How do I limit the data in graphs to last 30 days,

 

tvisha_0-1660562102425.png

I added a condition as , =Date(today())-Date(floor([Date Created]))<=30, however it then gives me below

 

tvisha_1-1660562176689.png

 

 

THanks, 

Rains

Labels (1)
1 Solution

Accepted Solutions
tvisha
Creator II
Creator II
Author

 I got this, 

 disable the "Continuous" auto  in the X-axis or Y-Axis

and then I was able to uncheck the "Include null values".

View solution in original post

3 Replies
its_rajvir
Creator
Creator

Hi,

Try this.

Create a measure:

Sum({<CreateDate = {">=$(= Date(Today()-30, 'DD/MM/YYYY'))"}>}YourDimension)

Edit your date format

Thanks

 

 

tvisha
Creator II
Creator II
Author

Hi,

I did limit it with a calculation, the problem is it is working in a bar chart but not on line chart now, as I am not able to limit null values,

 

tvisha_0-1660565756250.png

 

tvisha
Creator II
Creator II
Author

 I got this, 

 disable the "Continuous" auto  in the X-axis or Y-Axis

and then I was able to uncheck the "Include null values".