Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
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
You can use alternate states.
Do you know how to use them?
Enjoy your Qlik.
Kind regards,
Théo ATRAGIE.
Hi
No I dont know. Could you please let me know how to do it and if its in english much better.Thanks
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.