Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
jialiangyao
Contributor
Contributor
‎2018-06-12 10:43 PM

Is there a chart function or formula I can create to calculate a measure based on a dimension not shown in the pivot table?

Hi all,

Assuming I have data as below, Department, Location, Billing Category, Revenue and Weightage. My measure = (Revenue * Weightage) grouped by Department, Location and Billing Category.

before.PNG

Lets say I am only concerned about Category - "N". Based on the weightages which might not = to 100%, the total savings across Location (30, TX, China) should be = $3173+$232+$4276 = $7681. The "Actual Savings" is a calculated measure based on Revenue and Weightage.


If I want to show the total Across Department and Billing Category without Location as shown below, the measure will calculate across the new chart layout and give me the wrong "Actual Savings" result of $31,284.

after.PNG

Is it possible through any type of chart function, set analysis or what not, to factor in Location in my measure even if the dimension is not shown in the Chart.

Thanks!

275 Views
0 Likes
0 Replies