topic Re: Bar Chart with Single dimension? in QlikView

Bar Chart with Single dimension?

Tue, 05 May 2015 12:18:08 GMT

Hi friends,

Can we make a Bar chart (Stacked) or Thermometer chart or Ruler chart with one single dimension?

I have the data like

And i want to show the data like this

Is this possible in Qlikview? Can you help me here please...

Regards,

Kuldeep

ali_hijazi — Tue, 05 May 2015 12:27:14 GMT

add a new chart

select bar chart as chart type

in the Dimension Tab add the field Travel

and in the expression add something like this avg([%])

in Style tab select stacked

mohammadkhatimi — Tue, 05 May 2015 12:30:45 GMT

Plot Chart with single dimension as TRAVEL

then add expression as you have two expresion

then in style tab select stacked...

Hope this will helps you..

Regards

Mohammad

Tue, 05 May 2015 12:33:42 GMT

Hello Kuldeep,

I have tried it using bar chart, when you are using 1 dimension, stacked option is disabled.

So, work around for this is-

You can use Block chart with 1 dimension-Travel, expresion-Sum(%).

It will show you the expected output.

Please have a look on attached screenshot.

Tue, 05 May 2015 12:59:10 GMT

Thanks Ali, Mohammad and Vrushali

Ali - For single expression like avg(%), i am not able to see stacked option.

Mohammad - How to use two expression, as i just have one column % for expression.

Vrushali - This alternate solution was of great help...but i am still exploring other options to represent this data.

Regards,

Kuldeep

Tue, 05 May 2015 13:03:16 GMT

Do share, if you found any workaround for the same.