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

[#1]

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

[Anonymous]

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.).

[#3]

Hi

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