topic Re: Combo Chart with grouped dimension..HELP..!!!! in QlikView

Combo Chart with grouped dimension..HELP..!!!!

Tue, 20 Nov 2012 05:21:32 GMT

Hi All,

I have following requirement from a client.

where bars are the sales of a particular brand monthly in current year, and lines are sales for last year for same brands.

the black line is sales for total brand in current year,...

how to do this in qlikview.....Plz help....

Thanks

Arun Goel

Re: Combo Chart with grouped dimension..HELP..!!!!

Anonymous — Tue, 20 Nov 2012 05:46:39 GMT

Arun,

Use a combo chart and set analysis and you should be fine I think.

For the lines you use Sum(Sales) and add a set analysis selection of a particular year (or dynamically by using Year(Today())-1 for example to get 2011 etc.).

Re: Combo Chart with grouped dimension..HELP..!!!!

Tue, 20 Nov 2012 06:07:18 GMT

In combo chart - Expression tab

for every expression we display in bars and lines

write ur expr and choose ur required in display options

bar,line,symbol