Adding expression based on alternative state

Wed, 30 Apr 2014 20:26:29 GMT

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:

Re: Adding expression based on alternative state

swuehl — Wed, 30 Apr 2014 21:33:36 GMT

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

Re: Re: Adding expression based on alternative state

swuehl — Wed, 30 Apr 2014 23:03:48 GMT

Or like this with a bit more intuitive dimension filtering.

topic Re: Re: Adding expression based on alternative state in QlikView

Adding expression based on alternative state

Re: Adding expression based on alternative state

Re: Re: Adding expression based on alternative state