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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Bobi
Partner - Contributor II
Partner - Contributor II

Set expression.

I try to calculate CM1% (contribution margin in %). This shall be done for only 2019.

avg({$<$(vL.CY)>}((CM1)/([Net Sales Amount]))) is the one I have tried recently. That gives a little bit higher values than it should. 

vL.CY variable is: [Booking ActualDate]={1},[Booking YearsAgo]={$(=min("Booking YearsAgo"))}

 

This expression works for calculating the right CM1% value (however this summarize for longer period, I only want current year.)

sum({$<[Booking ActualDate]={1}>}[CM1])/sum({$<[Booking ActualDate]={1}>}[Net Sales Amount])

 

Anyone see what causes the error?

Labels (1)
0 Replies