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

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Adding expression based on alternative state

I have a stacked bar chart with two dimensions:

  1) Date - shown along the X axis as a bar chart

  2) Rule name - shown in the legend (stacked on each date bar with sum at top)

And one expression:

  1) Count the number of logs generated by each rule

Now I need to add the ability to compare two states using separate bars, yet keep the formatting the same. So, I tried the following:

Dimensions:

1) Date (same)

2) Rule Name (same)

Expression:

1) Count {[StateA]} - same expression

2) Count {[StateB]} - same expression

But this results in the two stated being displayed in the legend with the rules listed long the X axis along with the dates. How do I make it so the two states are displayed along the X axis and the rules remain in the legend and stacked? Simple screenshots below for better description:

AlternativeStates.jpg

2 Replies
swuehl
MVP
MVP

Maybe like attached, using a third calculated synthetic dimension for the state view.

swuehl
MVP
MVP

Or like this with a bit more intuitive dimension filtering.