topic Re: Dashboard design Question in App Development

Dashboard design Question

arusanah — Wed, 22 Aug 2018 12:54:58 GMT

GM Friends , Is there a way we can show images based on measure value in #1 KPI or text object.

if ( current year sale > prev year sale ,'arrow up' , if( current year sale < prev year sale , 'arrow down ','resize arrow'))

I can easily do it with Simple KPI extension , using :icon" , but client is not ready to use extension for security, so I need to find work around for it .

As you any help is highly Appreciated!

Re: Dashboard design Question

BalaBhaskar_Qlik — Wed, 22 Aug 2018 13:07:54 GMT

Hey, check this link:

Conditional Performance Indicators in Tables using HTML Unicode Chr() Values

Try this expression:

=if ( [current year sale] > [prev year sale], chr(9650) , if( [current year sale] < [prev year sale] , chr(9660), chr(9668)&chr(9658) ))

Re: Dashboard design Question

arusanah — Wed, 22 Aug 2018 15:33:22 GMT

Thank You Bala !!