topic Apply condition to bar chart dimension total in QlikView

Apply condition to bar chart dimension total

Anonymous — Thu, 05 Dec 2013 00:45:00 GMT

Hi,

Does anyone know as a way to conditionally show/hide a dimension total in a bar chart?

My dimension is Region (AMS,EMEA,APJ), in dimension limits tab properties of the chart, I've got checked "show total" label = WW

The problem is, I'm using section access for the region, therefore I want to hide WW total when they are restricted to just 1 region, because if it shows up, will show the same number as filtered region, and the user gets confused.

Here's an example if they are restricted to just "EMEA"

Re: Apply condition to bar chart dimension total

albertovarela — Thu, 05 Dec 2013 02:01:10 GMT

Hello Oscar,

I don't think it's possible to conditionally show/hide the 'Total bar' however what I have done in the past to get around this is to overlay 2 charts, 1 with the Total and the other without. Then use a simple count(DISTINCT Region)>1 to show/hide the object (on the layout tab).

Hope this helps...

Re: Apply condition to bar chart dimension total

Anonymous — Tue, 10 Dec 2013 22:16:36 GMT

Thanks Alberto, I never thought of that trick.