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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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