Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
Contributor II

List Box with Field independent to selection

Hi!

I'm comparing sales between two different periods. When I want to compare the actual sales I want to compare the selected month vs previous month. But when I compare actual vs budget then I want to compare the same month. So far I managed to create variables with the month and year selected and calculate  the previous month to add this into the set analysis but I want to create a copy of the list boxes containing the scenario (actual or budget), year and month so that the user can select what they will compare againts what. But since I'm using the same field from my input data, I cannot choose different values. How can I create a copy of the list boxes which reads the values from the same field but that are independent from eachoter? Here's an example of what I want to do:

Untitled.jpg

I basically want to make the selections (coming from the same field) independent so that I can save it into variables and add it to the set analysis.

 

Thanks!

 

 

1 Reply
Highlighted
Partner
Partner

Re: List Box with Field independent to selection

What you are trying to do is done by alternate states. More information here:
https://help.qlik.com/en-US/sense/November2018/Subsystems/Hub/Content/Sense_Hub/Visualizations/alter...

Plees ekskuse my Swenglish and or Norweglish spelling misstakes