topic Display Smiley based on values in QlikView

Display Smiley based on values

thierrytt1102 — Fri, 16 Sep 2011 07:50:20 GMT

Hi all,

I'm at a client who absolutely wants to have Smileys instead of traffic lights or gauge.

My question is simple: I need to have 3 smileys for 0 , 0,5 , 1.

How can I handle this?

Thx you very much for your help

Re: Display Smiley based on values

gandalfgray — Fri, 16 Sep 2011 08:27:07 GMT

Hi thierrytt

One solution is to create three text objects (which shows a smiley, that is they dont have text, and you put a smiley picture as background in Properties->General)

Then you add the show condition of your choice in Properties->Layout.

See the attached sample where I show one, two or three "I'm reloading" dependent on the value of sum(F2)

hth/gg

Display Smiley based on values

IAMDV — Fri, 16 Sep 2011 10:48:02 GMT

Gandalf - This is good idea.

thierrytt - I am curious to know... where do they want to see the smiley's? I mean which object - Pivot Table / Straight Table?

Cheers - Dv

Re: Display Smiley based on values

SunilChauhan — Fri, 16 Sep 2011 11:26:26 GMT

please see the attached file

hope this help

Re: Display Smiley based on values

thierrytt1102 — Wed, 21 Sep 2011 12:03:27 GMT

Hi DV,

That's actually a missing information of my request. My mistake...

indeed, I'd like the smiley to appear in a Straight Table. The answer of Sunil is then enough for me.

Thks a lot

T T