3 Replies Latest reply: Aug 24, 2015 11:57 AM by Andy Weir

# 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

• ###### 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.

• ###### 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..

• ###### 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