Qlik Community

Ask a Question

Integration, Extension & APIs

Discussion board where members can learn more about Integration, Extensions and API’s for Qlik Sense.

Our May 2021 end-to-end product release from Data Integration to Data Analytics is out! READ DETAILS
Showing results for 
Search instead for 
Did you mean: 

Evaluating background color expression in pivot table

Hi all,

I'm using the Capabilities API to get the model of a pivot table and build a custom JS table:

app.getObject('domID', objID).then(function(model){

     // Parse model and build custom table


The pivot table has 3 measures and each measure has a background color expression.

I noticed that this expressions come through in the measureInfo object, under qAttrExpression. The issue is that the expression comes through as it appears in Sense:

qFallbackTitle = "if(value > 20, green(), red())"

What's the best way to evaluate this expression and get a color value as a result that I can use in my custom table?



0 Replies