topic Re: [ASK] Chart with Custom / Extra Dimension in QlikView

[ASK] Chart with Custom / Extra Dimension

rendiyan — Tue, 18 Oct 2016 17:43:20 GMT

Hallo Qlik Master,

I have an issue to create chart (pivot) with extra calculated dimension.

So for simulation without pivot is like below :

Note : A, B are represent values

In my transaction table, I have column :

1. Group Lv 1 (Revenue, Cost Of Revenue)

2. Group Lv 2 (Rev1, Rev2, COR1, COR2, COR3)

2. Actual (A, B)

And to create "Gross Profit" i use metric table that not related to my transaction table.

my metric table contain :

And then i use MetricDesc as my dimension to calculate above condition (1st pic), so my expression is like below :

if(MetricOrder='1',sum({<Group Lv 1={'Revenue'}>} Actual),

if(MetricOrder='2',sum({<Group Lv 1={'Cost Of Revenue'}>} Actual),

MetricOrder='3',sum({<Group Lv 1={'Revenue'}>} Actual)+sum({<Group Lv 1={'Cost Of Revenue'}>} Actual)

)

But the problem is that my metric table can't handle more than 1 level dimension.

And i need to show pivot table like simulation below :

is there any way to achieve this inside 1 pivot table object?

Many thx

sunny_talwar — Tue, 18 Oct 2016 17:49:46 GMT

Do you have a sample you can provide where you are trying to do this and we might be able to help you out

rendiyan — Tue, 18 Oct 2016 18:23:53 GMT

Dear Sunny,

Thank you for your quick respond.

Here i attached a sample.

Best Regards

sunny_talwar — Tue, 18 Oct 2016 18:34:00 GMT

Like this?

rendiyan — Tue, 18 Oct 2016 18:39:12 GMT

yes, it could be the basic for my case.

Thank you