Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
sona_sa
Creator II
Creator II

vMAPE Calculation Help - Expression

Hi,

I have a scenario like this:

Please find the attached qvw.

1 Combo Chart is Calculation is simple - Sum(Sales_Qty) = Actual

Sum(SOP_CTS)  = Plan

Sum(Sales_Qty) - Sum(SOP_CTS) = vMAPE

This chart is displaying the data as 'per CATAGORY wise.

2nd Char is Group Level - MEELES is a group, where these are the Categories lies (stand alone). Total no. of category is 6 which belong to MEELES.

Down side graph I need vMAPE Calculation like - (Sum(Total vMAPE)/Sum(Total Actual)) * 100

Export 1 chart data to xls - (Sum(Total vMAPE) = 0.75

Sum(Total Actual)) - 4.70

= (0.75/4.70)*100 = 16.03

Same value i want in second chart - by selection of MEELES group - i.e - 16.03, But my current expression is giving me - 12.64.

0 Replies