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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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".