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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
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