topic Re: 2 Dimensions in a Single Bar Graph (Trellis/Slider?) in QlikView

2 Dimensions in a Single Bar Graph (Trellis/Slider?)

dmohanty — Mon, 28 Apr 2014 20:52:05 GMT

Hi All,

I have to show Total Sales by Quarter and Total Sales by Geography, but in a single Bar Graph. I am not sure much, but can it be done using Trellis or somehow a slider to select the Dimension?

Means 1st part of Trellis would show the Total Sales by Quarter and if I scroll or move the slider, I would see Total Sales by Geography.

Hope I am clear on this. Stress would not be on values, but just wanted if we can select a Dimension from Slider or using a Trellis

Can someone please show me by an example?

Re: 2 Dimensions in a Single Bar Graph (Trellis/Slider?)

javier_florian — Mon, 28 Apr 2014 21:31:51 GMT

Hi DMohanty,

Can you try with container? You can work simultaneously with different graphs.

-JFlorian

Re: 2 Dimensions in a Single Bar Graph (Trellis/Slider?)

Mon, 28 Apr 2014 21:57:13 GMT

You may:

1. use dimension group

2. use 2 graphs and swich them using container or conditional show

3. use data island with values as your column names and then use calculated dimension.

Find attached example.

regards

Darek

Re: 2 Dimensions in a Single Bar Graph (Trellis/Slider?)

MarcoWedel — Mon, 28 Apr 2014 22:04:30 GMT

Hi,

you could use this calculated dimension in your chart

=$(=only({<$FieldNo={$(vFieldSelector)},$Table={'tabCities'}>}$Field))

and use a slider to select the FieldNo as described in thread How to identify the first column in a table ?

regards

Marco

Re: 2 Dimensions in a Single Bar Graph (Trellis/Slider?)

MarcoWedel — Mon, 28 Apr 2014 22:07:47 GMT

Darek's suggestion to use grouped dimensions most likely is the best and easiest way to do this.

regards

Marco

Re: 2 Dimensions in a Single Bar Graph (Trellis/Slider?)

Mon, 28 Apr 2014 23:49:47 GMT

Marco,

but sometimes island for dimension selection gives you possibility to have some specific expressions (or expressions parts) with it.

Darek