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

Announcements
Qlik Connect 2026 Agenda Now Available: Explore Sessions
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