Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
kdavorin
Contributor II
Contributor II

Pivot table data based on listbox selection

Dear community members,

 

I would appreciate some help, since I an newbie to QlikView with a very limited amount of time to learn.

 

I have a listbox with the following values (year and month concatenated):

  • 202106
  • 202103
  • 202012
  • 202009
  • 202006
  • 202003
  • 201912
  • ...

The user is allowed to select only one value from the listbox (e.g.202106) and the other value (202006 - a year ago with regard to the selected value) should be calculated.

Then, I would like to show my data only for 202106 and 202006 in a pivot table. 

How can I achieve this?

 

Thank you very much for your time and effort.

0 Replies