Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

How to Create Conditional Color in Qliksense

hi,

I want to Show Total sales in text object  in qliksense... and i want Conditional Color that if Sales for this Year is Greater than Last Year

than Show Green either show Red.. i m using a KPI object Conditional Color Option but its not showing a Proper Color based on Condition.. so kinldy help me how to do that ... I can only use normal object not an Extension..

Expre..=if(Num(sum({$<fYear = {$(=Max(fYear))}>}amount)/10000000,'#,##0.00Cr')>Num(sum({$<fYear = {$(=Max(fYear)-1)}>}amount)/10000000,'#,##0.00Cr'),Green(),Red()) .... this Condition is working fine in Qlikview Text object ... kinldy Help me

3 Replies
alp
Not applicable

Re: How to Create Conditional Color in Qliksense

Hi Brijesh,

I think you need to evaluate the nested expression in your set analysis expression using the double quotation marks. Try with the following SA expression and let me know if it works in QS:

Expre..=if(Num(sum({$<fYear = {"$(=Max(fYear))"}>}amount)/10000000,'#,##0.00Cr')>Num(sum({$<fYear = {"$(=Max(fYear)-1)"}>}amount)/10000000,'#,##0.00Cr'),Green(),Red())


Regs,


Alvaro P.

Not applicable

Re: How to Create Conditional Color in Qliksense

but in qliksense its now accepting a condition for color its only having a Add limit options..

ogster1974
Not applicable

Re: How to Create Conditional Color in Qliksense

To use the KPI Object

-- KPI Measure Current Year

sum({$<fYear={$(=Max(fYear))}>} Amount)

To use your Add Limit parameter in the KPI Object set the conditional colour something like

-- Last Year to be set in Add limit

sum({$<fYear={$(=Max(fYear)-1)}>} Amount)

Colour below as red and above the limit as green.

Hope this helps

Regards

Andy