Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

mariamovasheli
New Contributor III

Date Variables

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.

1 Solution

Accepted Solutions

Re: Date Variables

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

3 Replies

Re: Date Variables

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
New Contributor III

Re: Date Variables

Thank you very much this extension is really helpful

agigliotti
Honored Contributor II

Re: Date Variables

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

did you try ?