topic Re: Simulate List Box with Pivot table in QlikView https://community.qlik.com/t5/QlikView/Simulate-List-Box-with-Pivot-table/m-p/1143993#M901525 <HTML><HEAD></HEAD><BODY><P> I couldnot attached the qvw. The solution is,change the expression 1 for: M<SPAN style="color: #0000ff; font-size: 8pt;">axString</SPAN><SPAN style="font-size: 8pt;">({1} </SPAN><SPAN style="color: #800000; font-size: 8pt;">Cct.CostCenterLevel1</SPAN><SPAN style="font-size: 8pt;"> &amp; </SPAN><SPAN style="color: #800000; font-size: 8pt;">Cct.CostCenterLevel2</SPAN><SPAN style="font-size: 8pt;">) </SPAN></P></BODY></HTML> Mon, 18 Jul 2016 08:04:11 GMT 2016-07-18T08:04:11Z Simulate List Box with Pivot table https://community.qlik.com/t5/QlikView/Simulate-List-Box-with-Pivot-table/m-p/1143991#M901523 <HTML><HEAD></HEAD><BODY><P>Hi Everyone,</P><P>I'm working in a Project where drill-down List boxes are not permitted and I'm trying to simulate one with a Pivot table, but when I select one item, the other Item values are lost. Can you help me please to resolve this issue or suggest me a better way to simulate drill-down List boxes with two dimensions . </P><P></P><P><BR />Thanks. </P><P>Attached qvw sample.</P><P><IMG alt="ImageListBox.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/131088_ImageListBox.png" style="height: auto;" /></P><P></P><P><SPAN style="color: #1f497d; font-family: 'Calibri','sans-serif'; font-size: 11pt; mso-fareast-font-family: Calibri; mso-fareast-theme-font: minor-latin; mso-bidi-font-family: 'Times New Roman'; mso-ansi-language: EN-US; mso-fareast-language: EN-US; mso-bidi-language: HE;"> </SPAN></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Simulate-List-Box-with-Pivot-table/m-p/1143991#M901523 2020-11-25T16:16:04Z Re: Simulate List Box with Pivot table https://community.qlik.com/t5/QlikView/Simulate-List-Box-with-Pivot-table/m-p/1143992#M901524 <HTML><HEAD></HEAD><BODY><P>Fixed.</P><P>File attached</P></BODY></HTML> Mon, 18 Jul 2016 08:01:22 GMT https://community.qlik.com/t5/QlikView/Simulate-List-Box-with-Pivot-table/m-p/1143992#M901524 2016-07-18T08:01:22Z Re: Simulate List Box with Pivot table https://community.qlik.com/t5/QlikView/Simulate-List-Box-with-Pivot-table/m-p/1143993#M901525 <HTML><HEAD></HEAD><BODY><P> I couldnot attached the qvw. The solution is,change the expression 1 for: M<SPAN style="color: #0000ff; font-size: 8pt;">axString</SPAN><SPAN style="font-size: 8pt;">({1} </SPAN><SPAN style="color: #800000; font-size: 8pt;">Cct.CostCenterLevel1</SPAN><SPAN style="font-size: 8pt;"> &amp; </SPAN><SPAN style="color: #800000; font-size: 8pt;">Cct.CostCenterLevel2</SPAN><SPAN style="font-size: 8pt;">) </SPAN></P></BODY></HTML> Mon, 18 Jul 2016 08:04:11 GMT https://community.qlik.com/t5/QlikView/Simulate-List-Box-with-Pivot-table/m-p/1143993#M901525 2016-07-18T08:04:11Z