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

Display Last 30 days data

Hi All,

I have a Pivot table where i want to display last 30 days data by default.

I also want to be able to have a filter with date fiield and should be able to view previous data when filter is selected.

Please help.

Thanks,

Monu

1 Reply
swarnendu
Creator II
Creator II

Try like this .


Sum({<Date = {">=$(=Addmonths(Max(Date),-1))"}>}Value_Field)