Combine a bar from each bar chart into one bar chart

[#1]

HI, attached is the screen of one of the bar charts in my Qlikview file.

I have serveral these bar charts with dimensions factor 1, factor 2, etc.

I want to pick the bar with value 1 from each of these bar charts and put them together on one bar chart.

Is it possible?

[Anonymous]

Hi,

in the Properties>Style>Select Sub Type as Stacked

[#3]

Hi,

this can be achieved easily if you Load these factor1 ,fatctor2 ..... in  a single field and use that field as a dimension

and in this expression use set analysis to take only value of 1.

Hope this Helps,

Vivek

[#4]

Hi Vivek,

The factor 1, factor 2 ... now are in separate fields. How to load them in a single field? Thanks for your advice.

[#5]

Hi,

While Loading your Data you can use cross table option to achieve this.

Can you upload your sample data ??

Regards,

Vivek