Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

fmazzarelli
Contributor III

target

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?


Immagine.png


14 Replies
jamajka1
Contributor

Re: target

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
Contributor III

Re: target

Hi,


I would like to replace the value with an image


for istance:


Target


1,003   


0,083  



vinieme12
Esteemed Contributor II

Re: target

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
Contributor III

Re: target

Hi

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

Immagine.png

vinieme12
Esteemed Contributor II

Re: target

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

imageinchart.JPG

vinay_bangari
Valued Contributor III

Re: target

vinieme12

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

fmazzarelli
Contributor III

Re: target

I confirm . Use Qlik Sense

vinieme12
Esteemed Contributor II

Re: target

oops didn't see Qliksense

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

vinay_bangari
Valued Contributor III

Re: target

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.

Community Browser