topic Re: Complex listbox expression in QlikView

Complex listbox expression

Fri, 07 Feb 2014 12:41:00 GMT

Hi all,

I am trying to set up a fairly complex listbox calculated expression but it does not seem to work.

i have 3 expressions in a pivot table

What i am trying to achieve is to make a listbox that contains as selections the result of the (2-1-3) expression

Is that even possible in the interface??

Regards

Re: Complex listbox expression

Fri, 07 Feb 2014 14:02:06 GMT

Hi You can add these Expressions into List Box Expression tab.

Please provide the qvw with scrambling the data.

Re: Re: Complex listbox expression

Sat, 08 Feb 2014 12:04:33 GMT

Here is a sample app.

If someone could help I would be grateful.

Re: Re: Re: Complex listbox expression

swuehl — Sat, 08 Feb 2014 14:05:31 GMT

Maybe like this?

Re: Complex listbox expression

Sat, 08 Feb 2014 19:29:24 GMT

Hi swuehl,

Thanks a lot for the try. But in your sample app what I am trying to select >=0 or <=0 on the list box I get positive and negative values as well which should not be the case.

My actual specification is to be able to select between positive and negative values.

If you can give it one more try I would appreciate it.

Kind Regards

Re: Re: Complex listbox expression

swuehl — Sat, 08 Feb 2014 19:43:25 GMT

This should do the trick.

Re: Complex listbox expression

Sat, 08 Feb 2014 20:04:32 GMT

That is superb....
You totally deserve the first place on the board