topic Need Bar chart Help in QlikView

Need Bar chart Help

Mon, 22 Aug 2011 10:11:05 GMT

Dear All,

Currently I am having problem with a bar chart having multiple dimensions and expressions.

I have Fields Category(CTC,ORTH,DARJ,DUST,OTHR),Blend Quantity,Loose Stock etc.

I am going to create a chart where Category wise Blend Qty and Loose Stock can be shown,

and another comparison of Year(This Year and Last Year) also can be shown in the same bar

with stack view.

For better understanding I am attaching a Picture what I want to do.

Please give me a response as soon as possible.

Thanks & Regards,

Koushik.

Need Bar chart Help

Anonymous — Mon, 22 Aug 2011 10:24:22 GMT

just a hint... for year over year comparison.. first get the dataset of previous year and current year in the same table in two different columns.. so that plotting can be done easily...

Need Bar chart Help

Mon, 22 Aug 2011 10:28:26 GMT

Dear Friend,

I want to create a bar chart.Please go through the Picture attached with that discussion.

Thanks for replying.

Re: Need Bar chart Help

swuehl — Mon, 22 Aug 2011 10:28:31 GMT

I would try your Category as first dimension, year second dimension.

Two expressions calculating blend QTY and stock.

Choose the appropriate (Stacked) style in style tab.

Hope this helps,

Stefan

edit:

If you have many years in your year dimension and you want to filter only this and last year, try a calculated dimension like

=if(Year=year(today()) or Year=year(addmonths(today(),-12)), Year)

edited by swuehl

Need Bar chart Help

Mon, 22 Aug 2011 11:20:04 GMT

Thanks For Your Help.

It is working fine.