Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Q&A with Qlik - Qlik Cloud Migration: Questions about migrating to Qlik Cloud? Catch the latest replay!
cancel
Showing results for 
Search instead for 
Did you mean: 
ss2q
Contributor III
Contributor III

Help need for date picker

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

3 Replies
theoat
Partner - Specialist
Partner - Specialist

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

Enjoy your Qlik.

Kind regards,
Théo ATRAGIE.

ss2q
Contributor III
Contributor III
Author

Hi 

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

theoat
Partner - Specialist
Partner - Specialist

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.
Capture d'écran 2024-02-28 101814.png
We have here 2 KPIs, the same formula is applied to them.
Capture d'écran 2024-02-28 101732.png
Assigned a state to the second visualization, in the aspect section.
Capture d'écran 2024-02-28 101828.png
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).
Capture d'écran 2024-02-28 101849.png
As you can see, by making selections in the filter pane belonging to our state, only the KPI with the same state is affected.
Capture d'écran 2024-02-28 101917.png

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.