Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

[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
Partner
Partner

Dear Sunny,

Thank you for your quick respond.

Here i attached a sample.

Best Regards

View solution in original post

4 Replies
Highlighted

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

Partner
Partner

Dear Sunny,

Thank you for your quick respond.

Here i attached a sample.

Best Regards

View solution in original post

Highlighted

Like this?

Capture.PNG

Highlighted
Partner
Partner

yes, it could be the basic for my case.

Thank you