topic Show sheets based on variable in QlikView https://community.qlik.com/t5/QlikView/Show-sheets-based-on-variable/m-p/820084#M536461 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I've done this million times before and I don't know why it doesn't work now. I'm trying to show a different sheet based on a selection in a list box. I've done it with a variable. Please, do look on my qvw and tell me what I'm doing wrong.</P><P></P><P>Thanks,</P><P>Adrian</P></BODY></HTML> Wed, 12 Nov 2014 15:00:55 GMT 2014-11-12T15:00:55Z Show sheets based on variable https://community.qlik.com/t5/QlikView/Show-sheets-based-on-variable/m-p/820084#M536461 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I've done this million times before and I don't know why it doesn't work now. I'm trying to show a different sheet based on a selection in a list box. I've done it with a variable. Please, do look on my qvw and tell me what I'm doing wrong.</P><P></P><P>Thanks,</P><P>Adrian</P></BODY></HTML> Wed, 12 Nov 2014 15:00:55 GMT https://community.qlik.com/t5/QlikView/Show-sheets-based-on-variable/m-p/820084#M536461 2014-11-12T15:00:55Z Re: Show sheets based on variable https://community.qlik.com/t5/QlikView/Show-sheets-based-on-variable/m-p/820085#M536462 <HTML><HEAD></HEAD><BODY><P>possibly a field event trigger on Date to change variable value</P></BODY></HTML> Wed, 12 Nov 2014 15:08:57 GMT https://community.qlik.com/t5/QlikView/Show-sheets-based-on-variable/m-p/820085#M536462 jpenuliar 2014-11-12T15:08:57Z Re: Show sheets based on variable https://community.qlik.com/t5/QlikView/Show-sheets-based-on-variable/m-p/820086#M536463 <HTML><HEAD></HEAD><BODY><P>You need to do a bit of dollar expanding. See attached qvw.</P></BODY></HTML> Wed, 12 Nov 2014 15:09:36 GMT https://community.qlik.com/t5/QlikView/Show-sheets-based-on-variable/m-p/820086#M536463 Gysbert_Wassenaar 2014-11-12T15:09:36Z Re: Show sheets based on variable https://community.qlik.com/t5/QlikView/Show-sheets-based-on-variable/m-p/820087#M536464 <HTML><HEAD></HEAD><BODY><P>Use =$(vSheet)=0,=$(vSheet)=1, =$(vSheet)=2 in the condition. Hope this helps.</P></BODY></HTML> Wed, 12 Nov 2014 15:16:01 GMT https://community.qlik.com/t5/QlikView/Show-sheets-based-on-variable/m-p/820087#M536464 2014-11-12T15:16:01Z