Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Generating the Images with comparision operators

Yr/Qtr Tr value Arrow
201001 100 Up Arrow image
201002 90 Down Arrow Image (because the Tr valule is lessthan the previous Tr value)
201003 120 Up Arrow Image (because the Tr valule is Greater than the previous Tr value)
201004 110 Down Arrow Image (because the Tr valule is lessthan the previous Tr value)

I created one table dashboard with the fields Yr/Qtr and Tr Value
And third field Arrow is calculated field which will show images in that field

I want the third field with the images (Up and Down) which I mentioned in the above

So how I can generate third field with the comparision operator and display the images.

Pls guide me

Thanks,

2 Replies
Not applicable
Author

Hi,

Would this be for a chart? or a textbox for like a report object? because i tried this before and the only solution i found was to use the font Wingdings "h" and "i" for the up and down arrow and i just added a color change for down to be red and up to be green in the font color with a formula

sample:

If([Tr value] > 100,'h','i')

using the wingdings3 font..

hope this helps..

prieper
Master II
Master II

Hi,

have a look into the ABOVE-function - see the attached file

HTH

Peter