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
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
cedfoning
Contributor
Contributor

Year reference in filter

Hello, 

here is my issue

I have a table campaign with the following data : 

Campaign 2018

Campaign 2019

Campaign 2020

i will like to have 2 filters :

- Follow-up year : contains lists of all campaign years (campaign 2018, campaign 2019, campaign 2020 for example)

The second filter depends on the first one

- reference year : if campaign 2020 is selected in the follow-up year filter, the reference year filter contains campaign 2018 and campaign 2019 data

 

any ideas ?

1 Reply
Vegar
MVP
MVP

I suggest you to look into the concept of Alternate State to solve your needs.