topic Re: Stacked Bar selection with single value in QlikView

Stacked Bar selection with single value

prat1507 — Wed, 25 Nov 2020 16:16:04 GMT

Hi All

I have a scenario where I'm making selections in a stacked bar chart, I want to select the primary dimension even when the measure value is 1 and not have any selections in the second dimension.

Please help.

Regards

Pratyush

Re: Stacked Bar selection with single value

uacg0009 — Wed, 23 Jan 2019 08:34:49 GMT

Hi Pratyush,
I think you can click the "bar" in your stacked bar chart, then you will select the primary dimension.
If what I understand is wrong, could you please give a sample to clarify your question?
Aiolos Zhao

Re: Stacked Bar selection with single value

prat1507 — Wed, 23 Jan 2019 08:45:06 GMT

Sure, I will quote an example here

Lets say I have data as below:

Cart, Fruits, Season, Price
A, Apple, Summer, 100
A, Banana, Summer, 20
A, Kiwi, Rainy, 10
B, Kiwi, Rainy, 40

Now if I create a stacked bar with my primary dimension as Season and secondary dimension as Fruits. I will get two bars, one for Summer and one for Rainy. I also add a filter here for Cart.

If I select value A in Cart, I would have Summer and Rainy with Apple, Banana and Kiwi showing sum of Summer as 120 and Rainy as 10. If I make any selections in the bar, Season filter is selected. But if I select value B in my cart filter, I would have only Rainy with Kiwi showing value as 40. If I make selection into the bar again, this time, not the Season but the fruit is selected. I don't want this to happen.

I think I have made this clear now.

Regards
Pratyush

Re: Stacked Bar selection with single value

uacg0009 — Thu, 24 Jan 2019 02:53:31 GMT

Hi Pratyush,
it's very very clear, I have to say that it has been long time to see the question that is so clear like this. now I really understand what you want.
In dimension tab, you can check the "Show All Values" selection of your "Season" dimension, the selection is in "Settings for Selected Dimension" part,
you may also need to check the "Suppress When Value Is Null"
Please try
Aiolos Zhao

Re: Stacked Bar selection with single value

uacg0009 — Thu, 24 Jan 2019 03:26:02 GMT

I forgot to say that you also need to un-check the "Suppress Zero-Values" in Presentation tab.