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: 
Not applicable

Interval in expression

Hi everyone,

Does anyone know if I can in table expression to check whether some percentage value less then other in some field?

I have table with field Year,Minimal Realization % and Bonus Amount (LCY),(picture below), what I want is to check all values from field minimal realization and gave him bonus amount if calculated value is less than values in minimal realization.

If my calculated vlaue is 93%, I want to gave him 10.000,00 bonus

1.png

Hope someone can help me

1 Reply
Not applicable
Author

Could you share your qvw so we can help you better?