Skip to main content
Announcements
SYSTEM MAINTENANCE: Thurs., Sept. 19, 1 AM ET, Platform will be unavailable for approx. 60 minutes.
cancel
Showing results for 
Search instead for 
Did you mean: 
varunreddy
Creator III
Creator III

How to show number and image in a single text object based on a value

Hi,

I am trying to show the 'Up Arrow' and the value when the value is greater than 0%.

'Down Arrow' and the value when the value is less than 0%.

No Image when it is 0%.

Is it possible to show Text and image in same text object based on the percentage?

I tried something like this, by which I can show value and image in one text object. But image is not dependent on value.

Thanks in advance!

Cheers,

Varun Reddy

7 Replies
sunny_talwar

I don't think this is possible, create overlapping text objects to do this, I guess .

or may be an extension

swuehl
MVP
MVP

jpenuliar
Partner - Specialist III
Partner - Specialist III

you might be able to cheat with a straight table:

varunreddy
Creator III
Creator III
Author

Hi Jonathan,

Is it possible to share QVW?

Thanks,

Varun Reddy. K

jpenuliar
Partner - Specialist III
Partner - Specialist III

here is another KPI example from same author:

Creating a KPI object in QlikView

varunreddy
Creator III
Creator III
Author

I tried it, but not sure how you got this

jpenuliar
Partner - Specialist III
Partner - Specialist III

the expression for the arrows to show green if 5.6 is greater than or equal to  5 :

=if(5.6  >= 5 ,'qmem://<bundled>/BuiltIn/arrow_n_g.png','qmem://<bundled>/BuiltIn/arrow_s.png')