Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

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.

jchang_snwl
New Contributor II

Several question pivot table config.

Hello,

I'm building a pivot table.

Few questions need help.

Here is the preliminary result of this pivot table.

PivotTable.PNG

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?

Thanks,

Josh