-
Re: question
Kaushik Solanki May 23, 2017 8:00 AM (in response to Saran Wanjiru)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
-
Re: question
Saran Wanjiru May 23, 2017 8:54 AM (in response to Kaushik Solanki )How do i do that please
-
Re: question
Kaushik Solanki May 23, 2017 8:57 AM (in response to Saran Wanjiru)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
-
Re: question
Saran Wanjiru May 24, 2017 2:37 AM (in response to Kaushik Solanki )@kaushik solanki
when i right click i cant get the option on Visual Cues
-
-
-
-
-
Re: question
Kamal Kumar Sanguri May 24, 2017 3:00 AM (in response to Kamal Kumar Sanguri)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. ! !
-
Test.qvw 152.8 K
-
Re: question
Saran Wanjiru May 24, 2017 3:05 AM (in response to Kamal Kumar Sanguri)hey is this Qlik sense desktop? am using qlik sense desktop
I want the colors to appear on all the 4 columns.
-
Re: question
Kamal Kumar Sanguri May 24, 2017 3:11 AM (in response to Saran Wanjiru)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.
-
Re: question
Kamal Kumar Sanguri May 24, 2017 3:15 AM (in response to Saran Wanjiru)one link from Qliksense help as well.
http://help.qlik.com/en-US/sense/3.2/Subsystems/Hub/Content/Colors/color-by-expression.htm
-
-
-