Qlik Community

Qlik Sense Integration, Extensions, & APIs

Discussion board where members can learn more about Integration, Extensions and API’s for Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
sarasmonu
Contributor

Set expression to get latest week Sales and Previous Quarter Sales in 2 different charts

Hi Team,

1. If i choose Quarter Year filter in my sheet, and depending on what Quarter Year i chose in the filter i want the latest Latest week sales of that quarter to be calculated.

2. I also want previous year sales value to be calculated. Previous Quarter Sales depending on what Quarter Year filter i choose.

Say if i choose Q3-2017 , it should display Q2-2017 Sales. If i choose Q1-2017, it should display Q4-2016.

However by default point 1 should display current work week sales in graph 1 and point 2 should display previous Quarter sales in graph 2.

Thanks for the help in advance

1 Reply
davidganly
New Contributor III

Re: Set expression to get latest week Sales and Previous Quarter Sales in 2 different charts