topic Re: Need help with a condition in QlikView

Need help with a condition

Thu, 02 Oct 2014 14:33:33 GMT

Hi, I have a button I would like to hide if the user hasnt selected a value from a column. Right now I am populating the value selected into a variable, so its like:

vName = Only(Table.Name)

So I would like to evaluate vName so that if it = '', then I will hide the button using the Show Condition. Any ideas how I can do this?

So IF vName = ''

then <hide>

ELSE

show.

Re: Need help with a condition

Thu, 02 Oct 2014 14:34:23 GMT

What would be even cooler, would be to leave the buttons, but just fade them out, as opposed to hiding them, if that were possible...

Re: Need help with a condition

alexandros17 — Thu, 02 Oct 2014 14:36:28 GMT

in properties of the button, tab layout, section show:

set in the conditional box:

=getselectedcount(myField) > 0

let me know

Re: Need help with a condition

Thu, 02 Oct 2014 14:37:24 GMT

Ah thanks, but the field is a string, not a number, will this make a difference as you have > 0 there. I was expecting ' '...

Nope that works perfectly! Thanks

Any ideas if I can just grey the button out and disable it, as opposed to hiding it?

Re: Need help with a condition

carvalguil — Thu, 02 Oct 2014 14:41:37 GMT

You don't need to use a variable.

Just right click the button and go to the Background color window. In the "Base Color" area, choose "Calculated" and add your formula. The one shown below set the button background as Blue if the selected value is equal 1 and a light blue if it's not equal 1.

if(Field = 1, ARGB(255, 0, 0, 255), ARGB(50, 0, 0,255))

Re: Need help with a condition

Thu, 02 Oct 2014 14:46:31 GMT

Cool, but even if its light blue, it will still be able to be enabled, right? I want to disable the function too.

Re: Need help with a condition

carvalguil — Thu, 02 Oct 2014 16:02:28 GMT

There is a "Enable Condition" in the Button Properties Page. Just set it to Field = 1 (my example) and it will be disabled when a value not equal 1 is selected.

Re: Need help with a condition

Thu, 02 Oct 2014 17:05:10 GMT

Perfecto. Many, many thanks.