topic Re: Sales Chart in QlikView

Sales Chart

sushil353 — Fri, 13 Mar 2015 09:32:24 GMT

Hi All,

I have yearly sales data category wise. I want to make a chart and show that yearly sales data category wise. Also in the same chart I want to show change %change in sales each year in each category. How can this be achived. Consider the sample data as below.

Year Sales Category

2015 50000 A

2014 60000 A

2013 30000 A

2012 25000 A

2015 70000 B

2014 80000 B

2013 30000 B

2012 95000 B

2015 50000 C

2014 70000 C

2013 30000 C

2012 35000 C

Re: Sales Chart

Gysbert_Wassenaar — Fri, 13 Mar 2015 10:15:52 GMT

See attached example

Re: Sales Chart

Fri, 13 Mar 2015 10:22:15 GMT

Hi,

In dimension put year and category fields. Then in style tab click on stacked button.I did that like this.

Re: Sales Chart

timanshu — Fri, 13 Mar 2015 11:22:27 GMT

Hi,

see the above image, correct values are shown in 4th and 5th column. When using dual function, values are incorrect. How?

And when we remove just dual or add text outside dual then data is also correct. How is this happening??

Re: Sales Chart

timanshu — Fri, 13 Mar 2015 11:29:51 GMT

Hi,

If you want it on backend, here is the attached solution

Re: Sales Chart

Sat, 14 Mar 2015 10:36:02 GMT

Hi @sushil_Kumar

I Tried in this way for given data from please check this qvw file .

Please give reply after seeing the file

Re: Sales Chart

fred_s — Sat, 14 Mar 2015 12:09:59 GMT

Or something like this..

see attch

Grtz. Fred

Re: Sales Chart

fred_s — Sat, 14 Mar 2015 12:35:36 GMT

Sorry, this one is a little better..

Grtz. Fred