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: 
Shniperson
Partner - Contributor
Partner - Contributor

Custom variable in background expression

Hello.

I'm trying to change background in table and wonder is it possible to create some "local" variable in background color expression? Something like this pseudo-code:

let x = SOME_VERY_LONG_EXPRESSION;

RETURN if(x < 10, GREEN(), if( x<20, BLUE(), if (x < 30, RED(), YELLOW())))

Because X is long expression so using it in every if statement is totally unreadable. And I do not want to create global variable - I have this expression only in one place.

Labels (1)
0 Replies