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: 
Karthick30
Creator
Creator

how to get last 30 days in a barchart dynamically

Hi,

 I have created a barchart which shows month date in dimension and count as measure.. Right now it is showing 12/1 to 12/17.. but if we select November in filter it is showing 30 days(november) records..

But my actual requirement is by default it has to show last 30 days in my bar chart dimension.. that is 11/17 to 12/17.. and depends on calender selection , it has to show 30 days from the month Iam selecting. Any way we can do that..

no calculation made in dimension field

 

 

 

Labels (1)
3 Replies
anat
Master
Master

sum({<[Year Field]=,[Month Field]=, [Your Date Field]={">=$(=Date(Today()-30))<=$(=Today())"} >} SalesVolume)

Karthick30
Creator
Creator
Author

Hi,

 I am not using any aggr function like Sum , count in Dimension.. Using direct date field in dimension.. 

Any formula without sum function

 

 

Karthick30
Creator
Creator
Author

Thanks for the reply. It worked in default view.. but when i changed the month in filter, data is not changing..