topic Re: Need to create stack bar graph in QlikView

Need to create stack bar graph

Wed, 02 Apr 2014 06:28:15 GMT

Dear All,

Greetings for the day.

I need to create a stack bar graph. X axis is "Month" and Y axis is "Sum(qty)". Now I need this Y axis bar as stack bar based on field "Customer Code".

I have 200 Customer code's in my file. So i can't give those many expression's. So Is there any other way to create stack bar based on customer code.

Please let me know how to create same. Thanks in advance.

Re: Need to create stack bar graph

muniyandi — Wed, 02 Apr 2014 06:30:43 GMT

Hi reena,

can you post some sample file.

Regards,

Muni

Re: Need to create stack bar graph

tresB — Wed, 02 Apr 2014 06:31:57 GMT

Use 'Customer Code' as second dimnesion. Goto Style tab->Sub Type->Stacked

Re: Need to create stack bar graph

Anonymous — Wed, 02 Apr 2014 06:33:30 GMT

Use Month and Customer as dimension and sum(qty) as expression.

Now in Style tab , change Subtype from Grouped to Stacked.

You will get the stack chart.

Regards

Nitin

Re: Need to create stack bar graph

Anonymous — Wed, 02 Apr 2014 06:36:19 GMT

Hi Reena,

You Can Add the Month & Customer Code into Dimension & in Expression you can write sum(qty).

then go to Style Tab select subtype as Stacked.

It will give you your expected output.

hope this help.

Regards,

Re: Need to create stack bar graph

muniyandi — Wed, 02 Apr 2014 06:36:22 GMT

Hi ,

Kindly verify my attachment file.

Regards,

Muni

Re: Need to create stack bar graph

MK_QSL — Wed, 02 Apr 2014 06:36:52 GMT

Like this?

Re: Need to create stack bar graph

Wed, 02 Apr 2014 06:41:13 GMT

Thanks for replies. I got the solution.