Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Highlighted
satyaprakash
Not applicable

on fly pivot table measure background color issue

Hi All,

We are building dynamic pivot table with a large number of columns(around more than 100). Columns are activated or deactivated based on expression in  'qCalCond'. 

 

As chart is dynamically generated some fields will have calculated expression as 0 in 'qCalCond'. Then, some of the measure columns background color is not coming (below screenshot).pivot_table_bg1.png

 But if are making dimensions and measures fields as static (either using only dimensions which are required for plotting chart for that selections or making 'qCalCond' as 1 for each dimension and measure). Then it is working fine. Below attached screenshot.

pivot_table_bg2.png

 

 

 

Any solutions for this.

Regards,

Satya

 

 

 

Labels (1)
2 Replies
anushree1
Not applicable

Re: on fly pivot table measure background color issue

Could you please share a sample application, also try using the only keyword in your expression  

satyaprakash
Not applicable

Re: on fly pivot table measure background color issue

Attaching sample mashup folder