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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Maria_m
Partner - Contributor
Partner - Contributor

One date picker for two states

Hello,

I'm creating a dashboard for prod calendar comparison, and I'm using the alternate states: State 1 for the right and State 2 the left grid chart.
I created buttons to allow the downtime type selection, and since they are based on variables, the buttons are shared for both states.
Now I need the same for the Date Picker widget: The user wants to pick the date interval once for both grid charts. 
I thought that I would just use the default state (or State 3) for the Date picker and then use the set analysis inside each grid chart's Date dimension to fetch the dates of the Default state (or State 3).

Unfortunately, couldn't find a way to do it.

Could you suggest a solution that you find the most "attractive" for such a use case?calendar comparison.png

Labels (6)
2 Replies
VBD
Partner - Creator II
Partner - Creator II

hello, you can try something like below in your second state

  • count({$<[Invoice Number] = State1::[Invoice Number]>} DISTINCT [Invoice Number])

https://help.qlik.com/en-US/qlikview/May2024/Subsystems/Client/Content/QV_QlikView/Examples%20of%20A...

Valentin Billaud
Next Decision
BrandonFontes
Partner - Contributor III
Partner - Contributor III

Você pode tentar modificar os cálculos dos dois objetos:

  • Objeto 1: Sum({<Data1 = p(Data1)>} Medida)
  • Objeto 2: Sum({<Data2 = p(Data1)>} Medida)
Project Leader and Qlik Specialist at Work Avanti Solutions | www.avantisolucoes.com.br