5 Replies Latest reply: Apr 11, 2016 8:19 AM by Ralf Becher RSS

    Working with 2 periods in QlikSense

    omar bensalem

      Hi all,

       

      I want to work with 2 periods in Qlik Sense but I can't figure out a way to do it;

       

      here's what I've done with QlikView:

       

      I have 4 variables for my 2 periods (vDateFrom1, vDateTo1, vDateFrom2, vDateFrom2)

       

      Capture.PNG

       

      example of the expression:

      Sum({<[Calendar date]={'>=$(=Date($(vDateFrom1)))<=$(=Date($(vDateTo1)))'}>}Montant_Vente)

       

       

      Now, I want to do the same thing in QlikSense; How can I ?

       

      I've tried to use 2 extensions I've found,

       

      DateRangePicker and input variables:

       

      with the input variables, I found out that it only can be text or number format !

       

      With the Date Range Picker here's what I did:

       

      Capture.PNG

       

      I've chosen periode 1: last 7 days / periode 2 : last 30 days

      the result is right, but what's appearing in the periods is so wrong (01/04/2016- 04/04/2016 !!

       

      Is there another way to handle this??