Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
fletcherty
New Contributor

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?

 

 

Community Browser