target

[fmazzarelli]

Hi Community,

I created a pivot table .

One of the columns ( measure) is the goal to be achieved with a formula obtained .

The target is relative to values ​​< 1 or> = 1 .

I used the color to show it but I'd replace the value ( in the picture indicated by the black arrow ) with an image.

Is it possible?

[JaMajka1]

Hi Fabio,

I would like to help you but actually I do not understand what is the problem. Could you please write again in different way what is the final visualization you want to have?

Regards,

Maria

[fmazzarelli]

Hi,

I would like to replace the value with an image

for istance:

Target

1,003   

0,083  

[vinieme12]

create two text boxes one with a happy smiley as background and other with sad.

PLace them on top of each other

Go to Layout >> Show >>  Select conditional

     and put your expression for happy smiley textbox as = if(Target >=1,1,0)

     put your expression for sadsmiley textbox as = if(Target <1,1,0)

[fmazzarelli]

Hi

thanks for the reply but I need to place the icon in a pivot table and replacing the red value ( example attached

[vinieme12]

ok, 

Add below expression after your Target expression

if([Target]>=1  , 'fullpath\happysmiley.png', 'fullpath\sadsmiley.png')

And change expression representation to Image

NOTE:  You cannot have both image an value in a single cell

[Anonymous]

vinieme12

This is in Qlik sense . But your screen shot shows qlikview. Can we do this in qlik sense

[fmazzarelli]

I confirm . Use Qlik Sense

[vinieme12]

oops didn't see Qliksense

let me try with an extension, as this is not inbuilt with qliksense

[Anonymous]

no problem. I am trying to use your logic in a sample app. But attached are the sample smileys in case if you don't have them.