Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.

Visual Cues in Pivot with different limits


I have a pivot table vithe 6 dimention values and 8 different expressions. See attached file

I have also loaded a list of target values. It's differet targets for each dimentions.

E.g.For one expression, Store A has a target of 99,55, store B 99,38 etc.

What i want to is to set the coulur to Red of an expression/dimention if the value is below the target value.

How can I do this?

2 Replies
New Contributor III

Re: Visual Cues in Pivot with different limits

Add an expression in the advanced formatting section for the respective Expression(s)...something like this:


Esteemed Contributor III

Re: Visual Cues in Pivot with different limits

As Jim suggested use the background expressions based on your Target values for each expression field.

Attached is the sample based on your excel. Changed the Field value for Field A lesser than target to get the red background. Check and let us know. Add the remaining target values as mentioned in the app.

Community Browser