1 Reply Latest reply: May 8, 2015 3:30 PM by Jonathan Poole RSS

    default dates

    Keith Roos

       

      Great system, but need the default date feature available in Qlik View added the Qlik Sense.  Have a report that is date sensitive and need it to open with Yesterday’s data as the default date. Users are getting annoyed with having to select a date before the data makes sense. Am I missing something easy or is it just a feature we need added to future updates of Qlik Sense?

       

        • Re: default dates
          Jonathan Poole

          Trigger don't exist in Qlik Sense... which is the method you would use to do this .

           

          but i think i may have an alternative for you:

           

          Lets say your load script loaded dates like this:

           

          Load

               ...

               DateField as MyDateField

          from ...

           

          Now, add a new 1 row table like this:

           

          Load

               $(=Today()-1) as MyDateField,

               'Yesterday' as KeyDates

          autogenerate 1;

           

          ---> this will load a 1 row table with yesterday's date joined to your core data model and a static value 'yesterday' as a keydate value

           

          Next, in the UI, create a bookmark where KeyDates='Yesterday' and save the QVF with the bookmark applied

           

          ...next time you open the QVF, the bookmark should be applied.

           

          I tested this after the app reloads and it still applies.

           

          Does this help ?