topic Re: Help in QlikView

Help

smilingjohn — Wed, 25 Nov 2020 16:16:04 GMT

Hi Expertise .

Need help, PLease find the attachment of the QVW app

I have a field called prirotiy

which has nubers from 1 to 60

i want to use a slider and make it three colours ...

from 1 to 20 red, 21 to 40 green and 41 to 60 blue

How can i achive this ..

Please help me achivung this .

in the edit script iam trying to wirte like this but it is showing error .

if(Priority >=0 and <20 ,'Low', if(Priority >20 and <40 ,'Medium',if(Priority >40 and <60 ,'High') as ChangedPriority,

rammarthi — Wed, 24 Jan 2018 12:48:02 GMT

Use if statement in the backend to create bins. Instead of slider can try using input box or list box on the bins created, that should help you.

smilingjohn — Wed, 24 Jan 2018 13:10:34 GMT

HI Ram,

What is bin ?

it will really great if u can please explain ..

Thanks

stabben23 — Wed, 24 Jan 2018 13:35:59 GMT

you have to do it like this:

=if(Priority >0 and Priority <21, 'low',
if(Priority >20 and Priority <41, 'medium','high')) as ChangedPriority

stabben23 — Wed, 24 Jan 2018 13:40:00 GMT

ex backgroud color

smilingjohn — Wed, 24 Jan 2018 13:59:13 GMT

Thanks for the reply Saffron.

Is there any way where i can make the Slider in three colours ?

stabben23 — Wed, 24 Jan 2018 14:15:30 GMT

Three color at the same time? otherwise try this

=aggr(if(Priority >0 and Priority <21, Yellow(), if(Priority >20 and Priority <41, blue(),red())),Priority)

stabben23 — Wed, 24 Jan 2018 14:20:57 GMT

Also change to single value

stabben23 — Wed, 24 Jan 2018 14:31:11 GMT

you dont need the aggr function, =if(Priority >0 and Priority <21, Yellow(), if(Priority >20 and Priority <41, lightgreen(),lightred())) is enough

smilingjohn — Wed, 24 Jan 2018 15:15:56 GMT

This is not working saffororn i did this

Anonymous — Thu, 25 Jan 2018 03:52:18 GMT

It is not clear exactly what you are trying to achieve. Could you please elaborate.