https://community.qlik.com/t5/QlikView/Qlikview-Buttons-Select-in-field/m-p/1607333#M507440 <P>Hi QV users</P><P>I have a variable flag in my Master Calendar 'Prevweek' which when =0 shows all dates, when =1 shows data for only previous week.</P><P>I am trying to create a button. I created a button and then assigned an action using 'select in field'</P><P>when i put 1 in search string, the button works one way i.e data changes from all dates to previous week's data, but doesn't go from prevweek's to all dates.</P><P>Any suggestions?</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="image.png" style="width: 988px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/16177iDE55F052258F71CE/image-size/large?v=v2&amp;px=999" role="button" title="image.png" alt="image.png" /></span></P> Sat, 16 Nov 2024 02:52:35 GMT rt_new_user 2024-11-16T02:52:35Z https://community.qlik.com/t5/QlikView/Qlikview-Buttons-Select-in-field/m-p/1607333#M507440 <P>Hi QV users</P><P>I have a variable flag in my Master Calendar 'Prevweek' which when =0 shows all dates, when =1 shows data for only previous week.</P><P>I am trying to create a button. I created a button and then assigned an action using 'select in field'</P><P>when i put 1 in search string, the button works one way i.e data changes from all dates to previous week's data, but doesn't go from prevweek's to all dates.</P><P>Any suggestions?</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="image.png" style="width: 988px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/16177iDE55F052258F71CE/image-size/large?v=v2&amp;px=999" role="button" title="image.png" alt="image.png" /></span></P> Sat, 16 Nov 2024 02:52:35 GMT https://community.qlik.com/t5/QlikView/Qlikview-Buttons-Select-in-field/m-p/1607333#M507440 rt_new_user 2024-11-16T02:52:35Z https://community.qlik.com/t5/QlikView/Qlikview-Buttons-Select-in-field/m-p/1607410#M507441 <P>Hi</P><P>Try using the following in the Select String box</P><P>=If(GetFieldSelections(PrevWeekFlag)=1,0,1)</P><P>Regards</P><P>Adrian</P> Tue, 30 Jul 2019 09:54:09 GMT https://community.qlik.com/t5/QlikView/Qlikview-Buttons-Select-in-field/m-p/1607410#M507441 atoz1158 2019-07-30T09:54:09Z https://community.qlik.com/t5/QlikView/Qlikview-Buttons-Select-in-field/m-p/1607541#M507442 Thanks<BR />It worked perfectly!!!<BR /> Tue, 30 Jul 2019 13:44:16 GMT https://community.qlik.com/t5/QlikView/Qlikview-Buttons-Select-in-field/m-p/1607541#M507442 rt_new_user 2019-07-30T13:44:16Z