Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Not applicable

question

Hi,

I am working with pivot table   i want color to my data according to the highest spent and lowest spent amount.

e.g over spending ranges from >= 1000000  color green() under spending is <1000000 color red()

How do I create the expression.

PROJECT IDBUDGETACTUAL BUDGETCONSUMED AMOUNTAVAILABLE BALANCEHeader 6Header 7

001

200000003000000010000000400000
00350000014000000567990600000
0024500000200000002760000100590
009300000025045003210000471230
0061500000056800001600005000
0071200000034600000123000045890
005500000233333331000000200001
01016000067777555600006600
Tags (1)
9 Replies

Re: question

Hi,

Pivot table property has one tab named "Visual Cues" you can define the upper value and lower value and as per the value you can define the color and other formatting also.

Regards,

Kaushik Solanki

Not applicable

Re: question

How do i do that please

Re: question

1. Right Click on the Pivot Table.

2. Click on Properties

3. Go to Tab "Visual Cues"

4. Enter upper value as "1000000".

5. Select Background color for that as Greeen.

6. Enter Lower value as "1000000".

7. Select Background color for that as Red.

8. Click on Apply.

9. Click on Ok.


Regards,

Kaushik Solanki

Not applicable

Re: question

@kaushik solanki

when i right click i cant get the option on Visual Cues

kamal_sanguri
Valued Contributor

Re: question

Hi,

you can update the condition here to say if amount is greater than something color it in this way.

Capture.PNG

kamal_sanguri
Valued Contributor

Re: question

Attaching a test copy for your reference. Here I have added expression to highlight background color and text color based on Budget amount.

You can update these expression on the fields of your choice. ! !

Not applicable

Re: question

hey is this Qlik sense desktop? am using qlik sense desktop

I want the colors to appear on all the 4 columns.

kamal_sanguri
Valued Contributor

Re: question

Oops.. It's not qliksense.. I added Qlikview document.

Please follow this QlikSense - pivot table - change color of cell vs average of grouping

This can be achieved in more or less similar way in Qliksense.

kamal_sanguri
Valued Contributor

Re: question

Community Browser