Date Variables

[mariamovasheli]

Hello, I have Complicated Issue and I even Don't know if it is possible in Qlik sense  by any chance if You had an experience or have any Idea Please Help me. I have chart Where I compere Quarters but I also need to have date selections of what I compare. To have like 2 date filters and  compare each other what I select on each. if there is another option to achieve this goal please share your ideas.

[kaushiknsolanki · Accepted solution]

Hi,

First of all Yes it is possible to do this in Qlik Sense.

Approach 1:

     Create 2 Inline table, one for From Date and other for To Date.

     Now create a variable which will store the selected values from above field.

     Then use set analysis to compare this against the actual data. Something like below.

     Sum({<Date = {"$(vFromDate)"}>}Sales)

     Sum({<Date = {"$(vToDate)"}>}Sales)

Approach 2:

     You can use extension for alternate state.

     http://branch.qlik.com/#!/project/5a3977e3af2a6e36deb1b391

Hope this helps.

Regards,

Kaushik Solanki

[mariamovasheli]

Thank you very much this extension is really helpful

[agigliotti]

this extension seems it doesn't works with April 2018 version.

did you try ?