topic Re: Help need for date picker in Featured Members

Help need for date picker

ss2q — Tue, 27 Feb 2024 06:16:57 GMT

I want to know how to make a date picker which only works for one KPi and does not change the results for the rest of the KPIs or charts when I select a range.

I created this but it does not work and shows me zero

Count({<ORDER_TYPE={'Awaiting shipping'}, DATE_FIELD={"$(vSelectedDate)"}>} DISTINCT ORDER_NUMBER)

I have created a variable called vselecteddate and defined the value the same as my column "DATE_FIELD". I want this date picker to work on one KPI only and once I give a range it should show me orders in that range and when I unselect it should show all

Re: Help need for date picker

theoat — Tue, 27 Feb 2024 10:12:23 GMT

You can use alternate states.
Do you know how to use them?

Enjoy your Qlik.

Kind regards,
Théo ATRAGIE.

Re: Help need for date picker

ss2q — Wed, 28 Feb 2024 05:00:29 GMT

No I dont know. Could you please let me know how to do it and if its in english much better.Thanks

Re: Help need for date picker

theoat — Wed, 28 Feb 2024 09:26:43 GMT

Alternate states permit you to make choices that will be restricted to views with the same state.
First, create an alternative state. To do this, go to the master items.

We have here 2 KPIs, the same formula is applied to them.

Assigned a state to the second visualization, in the aspect section.

Then, apply this same state to a filter pane (it is possible to apply one to a date picker, but I did not have data allowing it in my example).

As you can see, by making selections in the filter pane belonging to our state, only the KPI with the same state is affected.

You can read this article from Qlik if you want to know more about alternative states :
Utilisation d'états alternatifs à des fins d'analyse comparative | Aide Qlik Sense sous Windows

Enjoy your Qlik.

Kind regards,
Théo ATRAGIE.