topic Re: Make a bar static in Bar chart in QlikView

Make a bar static in Bar chart

qlikwiz123 — Sat, 16 Nov 2024 18:16:49 GMT

I have a stacked bar chart with two dimensions (one of them is Cyclic Group) and 4 expressions. Clicking on the dimensions drill down into next level cyclic groups. And clicking on any bars shows that one specific bar.

Is there a way to make one bar out of those 4 bars static? Meaning no matter what selections are made on other fields or dimensions within the chart, that one bar should always appear while the other bars change as per selections.

Re: Make a bar static in Bar chart

Kushal_Chawda — Fri, 31 Jul 2020 22:48:59 GMT

Can you share expected screenshot of Bar?

Re: Make a bar static in Bar chart

qlikwiz123 — Sun, 02 Aug 2020 00:06:06 GMT

This is first level in Dimension Cyclic Group:

So when I drill down on the dimensions or make any other selections on other fields in the Dashboard, the last bar (BCYJKY) should always stay. This is because the BCYJKY bar data is not connected to other columns and hence when I make any selection on other fields, it disappears. I need to make that one bar static no matter what selections a user makes and thus that bar should always appear even if other bars drill down or change.

Re: Make a bar static in Bar chart

Kushal_Chawda — Sun, 02 Aug 2020 14:39:18 GMT

Can you not exclude the selections via set? like below

sum({<Field1,Field2>}Sales)

Re: Make a bar static in Bar chart

MK9885 — Mon, 03 Aug 2020 15:20:18 GMT

Maybe use IF condition?
What is your backend expression?

What dimensions do you have?