Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

lamnaresh
New Contributor II

Is it possible to do conditional image change in Qliksense

Hi All,

Is it possible to do conditional image change in Background color expression on Qliksense ?

EXample is below

Quarter, Amount

Q1, 20000

Q2, 30000

Q3, 10000

Q4, 15000

Based on above example i want to display if sum(Amount) <20000 then Down arrow mark else up arrow mark.

Thanks and regards,

Naresh

2 Replies
devarasu07
Honored Contributor II

Re: Is it possible to do conditional image change in Qliksense

Hi,

Try to use like below, here  chr(9660) for up arrow and chr(9650)  for down arrow


if( Sum(Amount)<20000,  num(Sum(Amount),'$#,##0') & chr(9660) ,num(Sum(Amount),'$#,##0') & chr(9650)  )


and your measure text color expression as

if( Sum(Amount)<20000, red() ,Green() )

Capture.JPG

Thanks,

Deva

lamnaresh
New Contributor II

Re: Is it possible to do conditional image change in Qliksense

Hi Deva,

The above given example is working but i want to display traffic signals instead of up & down arrows. can you please tell me how to achieve this.

Thanks and regards,

Naresh.M

Community Browser