Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I would like to understand the following behavior:
Assuming there are 2 states, each has a Date filter.
When using a chart with 2 alternate state expressions, and a dimension (Date) without a state, how does the date
synchronizes with the dates selected in each state?
Thanks!
Short answer: It doesn't. If you want to include multiple states within an object, you must do so explicitly. This includes the default state (there's no such thing as "without a state").
Sorry for my awkward explanation..
I'm talking about a solution that works - a line chart.
Since I didn't develop it, I want to understand the logic..
The chart is Inherited state.
The lines expressions are for each state.
The date dimension is reflecting the 2 different states selections.
So if you select 01/2020 on state 1
and 06/2021 on state 2, you'll see both on the X axis.
I don't understand how the date (from the master calendar) is automatically linked to both states.
Thanks..
Without seeing the chart, I can only guess that passing the dates from each state is explicitly written into the specific formulas. See https://help.qlik.com/en-US/qlikview/May2021/Subsystems/Client/Content/QV_QlikView/Examples%20of%20A...
Hi Or,
The expression used is : sum({Group1} Qty), sum({Group2} Qty)
attached is a screen capture.
Thanks!
{Group1} and {Group2} tell each expression to refer to selections made in those states, but the formula itself (that is, sum(Qty) is still working off of the default group. Only the selection state is passed from the other groups. This is basically the same (in this selection scenario) as if you would have written
Sum({< Month = {'Feb','Mar','Apr'} >} Sales)
Thank you, Or!