Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
rendiyan
Partner - Creator
Partner - Creator

[ASK] Chart with Custom / Extra Dimension

Hallo Qlik Master,

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

So for simulation without pivot is like below :

Capture.PNG

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 :

Capture.PNG

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 :

Capture.PNG

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

Many thx

1 Solution

Accepted Solutions
rendiyan
Partner - Creator
Partner - Creator
Author

Dear Sunny,

Thank you for your quick respond.

Here i attached a sample.

Best Regards

View solution in original post

4 Replies
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
Partner - Creator
Partner - Creator
Author

Dear Sunny,

Thank you for your quick respond.

Here i attached a sample.

Best Regards

sunny_talwar

Like this?

Capture.PNG

rendiyan
Partner - Creator
Partner - Creator
Author

yes, it could be the basic for my case.

Thank you