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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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

0 Replies