Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Support Case Portal has moved to Qlik Community! Read the FAQs to start exploring Support resources.
cancel
Showing results for 
Search instead for 
Did you mean: 
Subba55
Contributor III
Contributor III

Without selection previous quarter in pie chart dynamically

Hii Guys,

I have pie chart, I want to show the previous quarter values in pie chart without any selection by expression its change dynamic,when user open the dashboard ,with selection it's show accordingly.

Can help me this anyone please.

Thanks in advance.

Regards,

Subba

1 Reply
Vegar
MVP
MVP

Assuming you have a date field, Date, and a value field, Amount, in your data model. if not then adjust my suggestion to your data model.

Sum({<[Date]={">=$(=quarterstart(max([Date]),-1))<=$(=quarterend(max([Date]),-1))"}>}[Amount])

Plees ekskuse my Swenglish and or Norweglish spelling misstakes