Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

rammuthiah
Contributor II

Show KPI based on Color

I am taking recent 2 days Data that are highlighted in yellow. If the previous date %value is lesser than current date % value, then the colour should be green, else red.
I have calculated the difference % for both date. Ie (9/13/2017 and 9/13/2017). But I have to show difference %  in color representing the increase or decrease in KPI Qlik sense.

Scenario : 1                   Scenario : 2

Date

Value

Date

Value

9/11/2017

10000

9/11/2017

10000

9/11/2017

10000

9/11/2017

10000

9/12/2017

15000

9/12/2017

15000

9/12/2017

15000

9/12/2017

15000

9/13/2017

30000

9/13/2017

25000

9/13/2017

30000

9/13/2017

25000

9/14/2017

35000

9/14/2017

35000

9/14/2017

35000

9/14/2017

35000

Difference

-5000

Difference

10000

diff %

17%

diff %

40%


But the colour is not changing accordingly.  Can anyone help how to show the diff % based on colour

SS.JPG

2 Replies
rittermd
Honored Contributor

Re: Show KPI based on Color

I am not clear from your screenshot what you have done.

You should be able to click on the left side of the color and pick a color and then pick a value.  Then do the same for the right side with a different color.

shraddha_g
Honored Contributor III

Re: Show KPI based on Color

If you want to assign colors for less than and greater than particular value then

add that value (or any expression) in fx you have highlighted and then you will see a black vertical line separating that bar in blue.

Now click on left part of bar and it will give you pallete of color. choose appropriate color and repeat same for right part of bar.

In this way if you will get 2 color when value is less or greater than specified value.

Community Browser