topic Re: Comparative Analysis - same chart in App Development

Comparative Analysis - same chart

DanaL — Fri, 15 Nov 2024 23:26:18 GMT

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!

Re: Comparative Analysis - same chart

Or — Tue, 07 Dec 2021 17:29:48 GMT

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

Re: Comparative Analysis - same chart

DanaL — Tue, 07 Dec 2021 19:18:39 GMT

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

Re: Comparative Analysis - same chart

Or — Wed, 08 Dec 2021 09:50:21 GMT

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%20Alternate%20States%20in%20Chart%20Expressions.htm

Re: Comparative Analysis - same chart

DanaL — Thu, 09 Dec 2021 06:44:44 GMT

Hi Or,

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

attached is a screen capture.

Thanks!

Re: Comparative Analysis - same chart

Or — Thu, 09 Dec 2021 09:49:44 GMT

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

Re: Comparative Analysis - same chart

DanaL — Thu, 09 Dec 2021 18:37:39 GMT

Thank you, Or!