Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.


Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

New Contributor II

Several question pivot table config.


I'm building a pivot table.

Few questions need help.

Here is the preliminary result of this pivot table.


1. Is it a way to use a variable to control what madelName I would like to show in this table

    for example I just want to show records which modelName = 'CZH*' or modelName='SO*'?

2. I would like to use background in Chart Properties > Expressions > one of expression > Background to give the same color to the same quarter, and mean while the color will change if the value of the Yield or KDPM is great than a threshold. It seems the Visual Cues can't override the background setting

3. How to change the font type and size of the header row?