topic Generating the Images with comparision operators in QlikView

Generating the Images with comparision operators

Tue, 28 Sep 2010 09:14:36 GMT

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,

Generating the Images with comparision operators

Tue, 28 Sep 2010 09:21:23 GMT

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

Generating the Images with comparision operators

prieper — Tue, 28 Sep 2010 09:48:27 GMT

Hi,

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

HTH

Peter