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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Maria_m
Partner - Contributor
Partner - Contributor

Measure in Alternate state Disables Selections of the Default States Dimentions

Hello,

 

I'm trying to use Alternate states for Comparison.
I have 1 dimension, which is different for each state (Calendar Scenario)
1 measure that is also different for each state (Downtime Duration)
And 2 dimensions that are required to be shared for both states: Lines and Dates.

I designed the dashboard with 2 heatmaps, both in Default states, but the second heatmap's measure is defined for an Alternate State ("St 2").

My idea of use case was: the user selects Scenario 1 for the default state, and Scenario 2 for the "St 2".
The heatmaps show the two scenarios respectively.
But the user is able to pick one Line, or one date, in either of the Heatmaps (or in the separate Filter panes), which will result to the application of those selections to both Heatmaps.

Unfortunately, that only works for the Heatmap which is in the default state (or, in any single state).
But once I have measures and dimensions in different states, I'm unable to select the Dimentions. And no selections made in any state on those dimentions, is able to filter out them on the heatmap with mixed states.

Do you know how to overcome this issue?
Or maybe there's another approach?

On the screenshot the Blue color highlights the St 2 (used for table on the right and for a Measure of the heatmap on the right. The rest is in the default state)
The formula I used for the measure is: sum({[State 2]} [DowntimeDuration(h)])

alternate states.jpg

Labels (2)
0 Replies