Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
nesonica
Contributor III
Contributor III

SUM results in 0

Hi guys,

unfortunately I do not get any results in the Bonus-free Route with the formula:

Sum({<PeriodMath={'>=$(vMinPeriodYear2)<=$(vMaxPeriod2)'},Route_FLAG={'yes'},[Margin after Bonus]=[Margin]>}Sales)

Could you please help me out with this one? Thanks in advance!

MATKLSalesRouteBonusBonus%Bonus-free RouteMarginMargin after Bonus
8990013.3803.380000-733,28-733,28
5190052.4652.465000415,12415,12
5190052.0832.083000351,04351,04
8990011.9451.94500019,8419,84
8990011.8621.86200085,3185,31
5190051.8191.819000306,99306,99
5190051.5881.588000267,49267,49
5190051.5661.566000263,7263,7
Labels (5)
3 Replies
felipedl
Partner - Specialist III
Partner - Specialist III

Quicly seeing the set analysis, the Route field is set to "yes" and its a numerical fields, that by itself won't work.

Would need to see the value of vMinPeriodYear2 and vMaxPeriod2 to identify if it's getting any value;
nesonica
Contributor III
Contributor III
Author

Thank you I just corrected the formula in my question, still no results unfortunately.
felipedl
Partner - Specialist III
Partner - Specialist III

Can you share both variables or the app as a whole?