Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Complex listbox expression

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

Tags (1)
1 Solution

Accepted Solutions
swuehl
Not applicable

Re: Re: Complex listbox expression

This should do the trick.

6 Replies
Not applicable

Re: Complex listbox expression

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

Please provide the qvw with scrambling the data.

Not applicable

Re: Re: Complex listbox expression

Here is a sample app.

If someone could help I would be grateful.

swuehl
Not applicable

Re: Re: Re: Complex listbox expression

Maybe like this?

Not applicable

Re: Complex listbox expression

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

swuehl
Not applicable

Re: Re: Complex listbox expression

This should do the trick.

Not applicable

Re: Complex listbox expression

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