[ASK] Chart with Custom / Extra Dimension

[rendiyan]

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]

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 · Accepted solution]

Dear Sunny,

Thank you for your quick respond.

Here i attached a sample.

Best Regards

[sunny_talwar]

Like this?

[rendiyan]

yes, it could be the basic for my case.

Thank you