topic Re: Dynamic Bar Chart Axis in QlikView

Dynamic Bar Chart Axis

cloud — Sat, 16 Nov 2024 03:52:42 GMT

Hi all,

I have Type A and Type B in the pivot table and a barchart.

Type A only display integers

Type B only displays percentage

How can I set it such that when I click on Type A, the barchart axis shows integers but when I click on Type B, the barchart axis shows percentage. Dynamically changing axis based on what the type displays.

Any help is appreciated! thanks

Re: Dynamic Bar Chart Axis

Vegar — Fri, 12 Apr 2019 04:16:54 GMT

Assuming that Type A and Type B are values in a dimension you could do this.

Create two bar chart expressions, the integer expression and the percentage expression.

In the conditional show for the expressions type this.

SubStringCount( Concat( DISTINCT '|' & YourTypesField & '|'), '|Type B|') = 1

SubStringCount( Concat( DISTINCT '|' & YourTypesField & '|'), '|Type A|') = 1