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

Question On Coloring Sql Query Results

 

Is it possible to return a background color from a SQL Query results? Currently we interpret a 1 or 0 to return the background color via an IF expression.  Instead we would like to return the correct background color in the SQL query as an additional value. 

 

 

We have tried returning LightRed(), ARGB(0,255,255,255), and ARGB(0,0,0,0) as both SQL results and a IF/Dual expression in the load statement. The background color doesn’t change.

 

 

How can we pre-load the background color for a field so it doesn’t happen during the User’s interaction with the data?

 

 

0 Replies