https://community.qlik.com/t5/App-Development/Sheet-Actions-Select-Field-in-Alternate-State/m-p/1879124#M72480 <P><A href="https://www.youtube.com/watch?v=tFyqOigqnUw" target="_blank">https://www.youtube.com/watch?v=tFyqOigqnUw</A></P> Mon, 10 Jan 2022 17:33:44 GMT arome 2022-01-10T17:33:44Z https://community.qlik.com/t5/App-Development/Sheet-Actions-Select-Field-in-Alternate-State/m-p/1877193#M72308 <P>Hello!</P> <P>I have a sheet that uses two alternate states (Range 1 and Range 2) for date range comparisons across two charts. I am trying to apply different defaults to each date range upon the sheet opening (mtd vs ytd).</P> <P>I have been using the 'sheet actions: select values in a field' for other defaults, but the field selection box does not allow input other than embedded data fields (therefore I cannot preface with the alternate state {[Range X]}).</P> <P>The workaround I am currently using is a 'sheet actions: apply bookmark' with the current date selections (see attached), but this requires an updated bookmark every month, due to the inability to use variables or expressions in a bookmark.&nbsp;(ex: [Range 1]: {InvoiceFiscalMonth = vCurrentFiscalMonth} )</P> <P>Is there any way to apply a default selection to an alternate state with a dynamic value?&nbsp;</P> Tue, 04 Jan 2022 19:38:18 GMT https://community.qlik.com/t5/App-Development/Sheet-Actions-Select-Field-in-Alternate-State/m-p/1877193#M72308 arome 2022-01-04T19:38:18Z https://community.qlik.com/t5/App-Development/Sheet-Actions-Select-Field-in-Alternate-State/m-p/1879124#M72480 <P><A href="https://www.youtube.com/watch?v=tFyqOigqnUw" target="_blank">https://www.youtube.com/watch?v=tFyqOigqnUw</A></P> Mon, 10 Jan 2022 17:33:44 GMT https://community.qlik.com/t5/App-Development/Sheet-Actions-Select-Field-in-Alternate-State/m-p/1879124#M72480 arome 2022-01-10T17:33:44Z