Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Depends how your data structure looks like but you probably can use PivotTable and moving the Year field to the top of the chart.
Not in straight, you can use pivot table and add year as dimension dragging it over ...
I agreed,
I want margin% only in Total. Is it possible in pivot table...?
Regards,
Faisal M A
Unfortunately no you'll have for any year ...
Thanks all for the prompt reply.
you can fool it by changing the color (Expression --> Text Color)
if(Dimensionality()=1, White(), Black())
or similar to fit your need
Could you please mark answers ....