topic Need Help in QlikView

Need Help

Nagaraju_KCS — Wed, 23 Sep 2015 10:27:38 GMT

Hi Community,

I have 3 buttons and one straight table..

I have 3 fields in my straight table..

ID, Name and salary...

I have given background color for sum(sal)

like this expression

=if(sum(sal)<5000, red(),

if(sum(sal)<=15000,Yellow(),

if(sum(sal)<=25000,Green(),RGB(0,190,345))))

Suppose, I have 3 buttons Test1, Test2 and Test3

If i am click Test1 button i want apply to this color background to chart

=if(sum(sal)<5000, red(),

if(sum(sal)<=15000,Yellow(),

if(sum(sal)<=25000,Green(),RGB(0,190,345))))

If i am click Test2 button

=if(sum(sal)<5000, Green(),

if(sum(sal)<=15000,Black(),

if(sum(sal)<=25000,Yellow(),RGB(100,134,210))))

Test3 Button,

=if(sum(sal)<5000, Yellow(),

if(sum(sal)<=15000,red(),

if(sum(sal)<=25000,Green(),RGB(225,255,255))))

Depends on button selection i want change straight table background color for sum(sal)....

Thanks in Advance..

simenkg — Wed, 23 Sep 2015 10:29:39 GMT

Create 3 variables that contain the color codes.

for each button use Action - External - Set Variable to change the values of the 3 variables.

sunny_talwar — Wed, 23 Sep 2015 10:30:53 GMT

I guess create one variable which is set to a different numbe by the three buttons. and then use this may be:

Pick(Match(vVar, 1, 2, 3),

if(sum(sal)<5000, red(),

if(sum(sal)<=15000,Yellow(),

if(sum(sal)<=25000,Green(),RGB(0,190,345)))),

if(sum(sal)<5000, Green(),

if(sum(sal)<=15000,Black(),

if(sum(sal)<=25000,Yellow(),RGB(100,134,210)))),

if(sum(sal)<5000, Yellow(),

if(sum(sal)<=15000,red(),

if(sum(sal)<=25000,Green(),RGB(225,255,255)))))

qlikmsg4u — Wed, 23 Sep 2015 10:33:56 GMT

Check the attached application.