Help

[smilingjohn]

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]

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]

HI Ram,

What is bin ?

it will really great if u can please explain ..

Thanks

[stabben23]

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]

ex backgroud color

[smilingjohn]

Thanks for the reply Saffron.

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

[stabben23 · Accepted solution]

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]

Also change to single value

[stabben23]

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

[smilingjohn]

This is not working saffororn i did this