topic Re: Bar Chart Qlikview in QlikView

Bar Chart Qlikview

dandaanilreddy — Wed, 25 Nov 2020 16:16:04 GMT

Hello developers

I have created a bar chart with 3 expressions my requirement is the chart should display only 2 bars in one bar 1 expression and in the second bar its should display 2 expressions like a stacked bar is it possible in qlikview? Please let me know.

Thanks

Anil Danda

Re: Bar Chart Qlikview

sunny_talwar — Wed, 14 Sep 2016 16:56:09 GMT

Check this thread and see if this helps:

Clustered-Stacked Column and Bar Charts in QlikView

Re: Bar Chart Qlikview

dandaanilreddy — Wed, 14 Sep 2016 17:03:10 GMT

Hi Sunny

Thanks for the response but it doesn't helped me. I don't have any dimensions in my chart,i have 3 expressions but i want to display only 2 bars in one bar 1 expression and in another bar 2 expressions the second bar should be a stacked bar.

Thanks

Anil

Re: Bar Chart Qlikview

sunny_talwar — Wed, 14 Sep 2016 18:24:20 GMT

If you are able to share a sample, I might be able to help you out. In this case you will need to create a dimension, but how exactly can it be done will be based on your data

Re: Bar Chart Qlikview

Anil_Babu_Samineni — Thu, 15 Sep 2016 03:30:47 GMT

I don't this so, but we will try if your share the data

Re: Bar Chart Qlikview

avinashelite — Thu, 15 Sep 2016 03:33:51 GMT

Explain your requirement with screenshots/images so that it will be helpful for us to understand the requirement

Re: Bar Chart Qlikview

Anonymous — Thu, 15 Sep 2016 03:47:28 GMT

No, You can't have Grouped and stacked together for your expressions.

Re: Bar Chart Qlikview

Digvijay_Singh — Thu, 15 Sep 2016 03:57:19 GMT

See if this can help -

create stack and group bars in a same graph

Re: Bar Chart Qlikview

ToniKautto — Thu, 15 Sep 2016 04:23:54 GMT

The attached is an example of how you keep one expression in one bar, and stack two expressions in an other bar.

To do this you must have a dimension over which the expressions can be grouped. If there is not real dimensions, we can fake it. In the example I have used ValueList() to generate dimension values. The dimension values are then used to place the expression in the desired bar. See the straight table for overview on what the data points look like.

Re: Bar Chart Qlikview

Anil_Babu_Samineni — Thu, 15 Sep 2016 05:50:45 GMT

Thanks Toni. New to me