Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

Help

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,

1 Solution

Accepted Solutions
Highlighted
Master
Master

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)

View solution in original post

10 Replies
Highlighted
Creator
Creator

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.

Highlighted
Creator III
Creator III

HI Ram,

What is bin ?

it will really great if u can please explain ..

Thanks

Highlighted
Master
Master

you have to do it like this:

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

Highlighted
Master
Master

ex backgroud color

Highlighted
Creator III
Creator III

Thanks for the reply Saffron.

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

Highlighted
Master
Master

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)

View solution in original post

Highlighted
Master
Master

Also change to single value

Highlighted
Master
Master

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

Highlighted
Creator III
Creator III

This is not working saffororn i did this