https://community.qlik.com/t5/App-Development/Pivot-table-data-based-on-listbox-selection/m-p/1830499#M68439 <P>Dear community members,</P><P>&nbsp;</P><P>I would appreciate some help, since I an newbie to QlikView with a very limited amount of time to learn.</P><P>&nbsp;</P><P>I have a listbox with the following values (year and month concatenated):</P><UL><LI>202106</LI><LI>202103</LI><LI>202012</LI><LI>202009</LI><LI>202006</LI><LI>202003</LI><LI>201912</LI><LI>...</LI></UL><P>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.</P><P>Then, I would like to show my data only for 202106 and 202006 in a pivot table.&nbsp;</P><P>How can I achieve this?</P><P>&nbsp;</P><P>Thank you very much for your time and effort.</P> Mon, 23 Aug 2021 11:40:34 GMT kdavorin 2021-08-23T11:40:34Z https://community.qlik.com/t5/App-Development/Pivot-table-data-based-on-listbox-selection/m-p/1830499#M68439 <P>Dear community members,</P><P>&nbsp;</P><P>I would appreciate some help, since I an newbie to QlikView with a very limited amount of time to learn.</P><P>&nbsp;</P><P>I have a listbox with the following values (year and month concatenated):</P><UL><LI>202106</LI><LI>202103</LI><LI>202012</LI><LI>202009</LI><LI>202006</LI><LI>202003</LI><LI>201912</LI><LI>...</LI></UL><P>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.</P><P>Then, I would like to show my data only for 202106 and 202006 in a pivot table.&nbsp;</P><P>How can I achieve this?</P><P>&nbsp;</P><P>Thank you very much for your time and effort.</P> Mon, 23 Aug 2021 11:40:34 GMT https://community.qlik.com/t5/App-Development/Pivot-table-data-based-on-listbox-selection/m-p/1830499#M68439 kdavorin 2021-08-23T11:40:34Z