5 Replies Latest reply: May 11, 2017 11:47 AM by Stanislav Strogiy RSS

    How to create start_date and end_date ?

    Vasiliy Beshentsev

      Hello!

      So i got some formulas, which calculate some counts:

       

      1)

      1.png

       

      2)

      2.png

      I want to create 2 filters on my list in Qlik Sense app. Like this:

       

      3.png

      I replace this exact dates with field (or variable?) in formulas.

      Then when i choose some dates in this filters i want that this filters works over my formulas.

      How to do that?

        • Re: How to create start_date and end_date ?
          Stanislav Strogiy

          Made an example with field selections.

          During load script I made two fields named StartTime and EndTime. In Calculation I used Set Analysis for finding sum between selected values.

           

          Filter selection can be made only by fields. If you don't want to use variables you need to lad them by script. Workaraound with development of formulas with If() statemend to avoid calculating with wrong input values. It can be made like:

          if(min(StartTime) > max(EndTime), 'Cahnge input option for dates. Start date Can't be grater than End Date')