Bar Chart with Single dimension?

[#1]

Hi friends,

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

I have the data like

Travel	%
Plan A	58%
Plan B	42%

And i want to show the data like this

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

Regards,

Kuldeep

[ali_hijazi]

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]

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

[#4]

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.

[#5]

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

[#6]

Ok

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