topic Re: Clear Color on Click clear button! in QlikView

Clear Color on Click clear button!

Tue, 05 Mar 2013 10:44:02 GMT

Hi everyone!

I need to change color when I click on my button ( my button select many records with a macro) , when I clik on clear button i need to restore default color...

I'm able to change color on click but I can not restore default color when I click clear button on top of the navgation bar.

Anyone can help me???

Thanks!!!

Re: Clear Color on Click clear button!

sushil353 — Tue, 05 Mar 2013 11:49:50 GMT

what color u want to change. Can u explain your requirement with example?

Re: Clear Color on Click clear button!

Tue, 05 Mar 2013 12:26:14 GMT

I want to change the background color of the button if is selected, and restore the default color when i click on clear on top.

After this action (I select two fields with macro and I change the button color in green..see the image)...if I click on clear button i want to restore the background color "white" for the button...

Re: Clear Color on Click clear button!

mikecrengland — Tue, 05 Mar 2013 16:57:02 GMT

You could try using GetFieldSelections() or GetSelectedCount() in the background color of the button. Something like:

If(GetFieldSelections(Field) = 'Type C', Green(), ARGB(50,192,192,192))

Re: Clear Color on Click clear button!

Wed, 06 Mar 2013 09:06:04 GMT

It's work...but if i have two button that return the same selection all two button become green! Can I escape of this situation???

For example :

Button A: return all product sum(price)=$100

Button B: return all product sum(price)=$50

If the result of the sum() is equal and I press button B also button A become green..can escape???

Thanks...

Re: Clear Color on Click clear button!

sushil353 — Wed, 06 Mar 2013 09:37:39 GMT

Hi jinmat,

One way you can use this functionality by using variable and Clear All button instead of Clear from the tool bar

Please find the attached sample app.

Hope this will help you.

If it is possible for you to share the sample app then i can try on your app.

HTH

Sushil

Re: Clear Color on Click clear button!

Wed, 06 Mar 2013 10:33:37 GMT

I solved with two variables and when i clik on button A then before i set variable b=0...and vice versa

varA=sum()

varB=sum()

On Button A

varB=0

If(GetFieldSelections(Field) = 'varA', Green(), ARGB(50,192,192,192))

On Button B

varA=0

If(GetFieldSelections(Field) = 'varB', Green(), ARGB(50,192,192,192))

Thanks for help...