Several question pivot table config.

Anonymous — Tue, 05 Apr 2016 00:02:18 GMT

Hello,

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?

Thanks,

Josh

topic Several question pivot table config. in QlikView

Several question pivot table config.