9 Replies Latest reply: May 24, 2017 3:15 AM by Kamal Kumar Sanguri

question

Saran Wanjiru May 23, 2017 7:57 AM

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 ID	BUDGET	ACTUAL BUDGET	CONSUMED AMOUNT	AVAILABLE BALANCE
001	20000000	30000000	10000000	400000
003	500000	14000000	567990	600000
002	4500000	20000000	2760000	100590
009	3000000	2504500	3210000	471230
006	15000000	5680000	160000	5000
007	12000000	34600000	1230000	45890
005	500000	23333333	1000000	200001
010	160000	67777555	60000	6600

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
Like Show 0 Likes (0)

Actions
- Re: question
  
  Saran Wanjiru May 23, 2017 8:54 AM (in response to Kaushik Solanki )
  
  How do i do that please
  
  Like Show 0 Likes (0)
  
  Actions
  - 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
    
    Like Show 0 Likes (0)
    
    Actions
    - 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
      
      Like Show 0 Likes (0)
      
      Actions
Re: question

Kamal Kumar Sanguri May 24, 2017 2:55 AM (in response to Saran Wanjiru)

Hi,
you can update the condition here to say if amount is greater than something color it in this way.
Like Show 0 Likes (0)

Actions
- 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
  
  Like Show 0 Likes (0)
  
  Actions
  - 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.
    
    Like Show 0 Likes (0)
    
    Actions
    - 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.
      
      Like Show 0 Likes (0)
      
      Actions
    - 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
      
      Like Show 0 Likes (0)
      
      Actions

Go to original post