topic ValueList with conditional values in QlikView

ValueList with conditional values

Thu, 12 Apr 2012 09:53:10 GMT

Hi everybody,

I'm trying to use a Valuelist to fill a Listbox, but I need to add a conditional value to my list.

My formula is something like:

=ValueList('Alpha', 'Beta', If(GetSelectedCount(myField)>0,'Gamma','Delta') )

Does the ValueList allow such an expression? How can I write it?

Tks

jagan — Thu, 12 Apr 2012 10:05:52 GMT

Hi,

Create a variable with the expression

vTest = If(GetSelectedCount(F1)>0,'Gamma','Delta')

Now use this variable in

=ValueList('Alpha', 'Beta', vTest )

Check attached file.

Regards,

Jagan.

CELAMBARASAN — Thu, 12 Apr 2012 10:09:38 GMT

Hi,

Yes you can use like that.

Celambarasan

Thu, 12 Apr 2012 10:14:49 GMT

Creating a variable is always the easyest shortcut...

thanks jagan

bye