Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Dear Sunny,
Thank you for your quick respond.
Here i attached a sample.
Best Regards
Do you have a sample you can provide where you are trying to do this and we might be able to help you out
Dear Sunny,
Thank you for your quick respond.
Here i attached a sample.
Best Regards
Like this?
yes, it could be the basic for my case.
Thank you