Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
DanaL
Creator
Creator

Comparative Analysis - same chart

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!

 

 

Labels (2)
6 Replies
Or
MVP
MVP

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").

DanaL
Creator
Creator
Author

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..

Or
MVP
MVP

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...

 

DanaL
Creator
Creator
Author

Hi Or,

The expression used is : sum({Group1} Qty), sum({Group2} Qty)

attached is a screen capture.

Thanks!

Alternate States.png

 

 

Or
MVP
MVP

{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)

DanaL
Creator
Creator
Author

Thank you, Or!