Qlik Community

Qlik Sense App Development

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

jblomqvist
Contributor II

How to use Conditional Colours option in the KPI Object for simple CYTD vs LYTD comparision?

Hi All,

I have the following Expression in the KPI Object:

Sum({<CurYTDFlag={1}>}Sales)

How can I use Conditional Colours to change the output of the KPI so that if Sales for Current Year are higher than Last Year, then it must be Green, otherwise Red.

CYTD Sales: Sum({<CurYTDFlag={1}>}Sales)

LYTD Sales: Sum({<LastYTDFlag={1}>}LineSalesAmount)

How do I need to configure the Conditional Colours for this?

2 Replies
undergrinder
Valued Contributor II

Re: How to use Conditional Colours option in the KPI Object for simple CYTD vs LYTD comparision?

Hi John,


Select the CYTD Sales KPI , and add conditional color, and add limit with the LYTD Sales formula. Set the upper range green, and the lower range red.

2016-07-01 13_50_54-Tutorial - teszt - AdventureWorks _ Sheets - Qlik Sense.png

G.

Highlighted
lironbaram
Honored Contributor II

Re: How to use Conditional Colours option in the KPI Object for simple CYTD vs LYTD comparision?

hi

you open the measure in edit mode

switch on conditional colors

then

click "add limit"

in the function box that appears you type your expression for last year sales ,

then in the color plate you select the left color as red and the right as green

you should have something like this

Untitled.png

Community Browser