topic Re: Straight Table Chart in QlikView

Straight Table Chart

Thu, 12 Feb 2015 11:46:04 GMT

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 — Thu, 12 Feb 2015 11:48:21 GMT

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 — Thu, 12 Feb 2015 11:48:22 GMT

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 — Thu, 12 Feb 2015 11:50:04 GMT

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

Thu, 12 Feb 2015 11:58:39 GMT

I agreed,

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

Regards,

Faisal M A

alexandros17 — Thu, 12 Feb 2015 11:59:33 GMT

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

Thu, 12 Feb 2015 12:02:31 GMT

Thanks all for the prompt reply.

giakoum — Thu, 12 Feb 2015 12:03:54 GMT

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

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

or similar to fit your need

alexandros17 — Thu, 12 Feb 2015 12:09:22 GMT

Could you please mark answers ....