Straight Table Chart

[#1]

All,

I have one straight table report like following in Qlikview,

I want my report look like following,

Is there any option in qlikview...?

Regards,

Faisal M A

[PrashantSangle]

Hi,

Yes it is possible,

Use pivot table chart

take Year and Product Group as dimension

and take create 2 expression for Sales and Margin

Regards

[robert_mika]

Depends how your data structure looks like but you probably can use PivotTable and moving the Year field to the top of the chart.

[alexandros17]

Not in straight, you can use pivot table and add year as dimension dragging it over ...

[#5]

I agreed,

I want margin% only in Total. Is it possible in pivot table...?

Regards,

Faisal M A

[alexandros17]

Unfortunately no you'll have for any year ...

[#7]

Thanks all for the prompt reply.

[giakoum]

you can fool it by changing the color (Expression --> Text Color)

if(Dimensionality()=1, White(), Black())

or similar to fit your need

[alexandros17]

Could you please mark answers ....