Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
arusanah
Creator II
Creator II

Dashboard design Question

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!

1 Solution

Accepted Solutions
balabhaskarqlik

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) ))

View solution in original post

2 Replies
balabhaskarqlik

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) ))

arusanah
Creator II
Creator II
Author

Thank You Bala !!