Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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

Labels (1)
0 Replies