topic Re: Creating Chart Help in QlikView

Creating Chart Help

Thu, 13 Aug 2015 18:44:07 GMT

Hi All,

I have requirement where I need to display the % of Sales from Total sales and Sales Amount in Bar chart. Currently I am able to show either % or Amount in Bar chart as Data point.

To be clear I would like to create chart like below

I have sample data like below

Year, Sales, Category
2010, 350,Cat1
2010, 150,Cat2
2010, 175,Cat3
2011, 300,Cat1,
2011, 220,Cat2
2011, 190,Cat4
2011, 220,Cat5
2012, 250,Cat1
2012, 200,Cat2
2012, 320,Cat3

Re: Creating Chart Help

Kushal_Chawda — Thu, 13 Aug 2015 18:50:54 GMT

Like this?

See the attached

Re: Creating Chart Help

Thu, 13 Aug 2015 18:56:59 GMT

See attached.

Re: Creating Chart Help

Qrishna — Thu, 13 Aug 2015 19:01:26 GMT

The closer to your requirement we can get is :

See attached.

Re: Creating Chart Help

Thu, 13 Aug 2015 19:05:32 GMT

Hi Krishna,

I want the values inside the segment, not on axis. Much appreciated for reply

Re: Creating Chart Help

Thu, 13 Aug 2015 19:16:48 GMT

Re: Creating Chart Help

Qrishna — Thu, 13 Aug 2015 19:35:17 GMT

You can Go with srukmana‌'s app or see attached.

Thanks

Re: Creating Chart Help

awhitfield — Fri, 14 Aug 2015 10:12:11 GMT

You need to have to expression, one to create the bar and % figure (bar and values on data points) and a second for the total sales (just values on data point)

HTH - Andy

Re: Creating Chart Help

Fri, 14 Aug 2015 12:03:17 GMT

thank you all