Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
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
Highlighted
MVP
MVP

Re: Re: Complex listbox expression

This should do the trick.

View solution in original post

6 Replies
Highlighted
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.

Highlighted
Not applicable

Re: Re: Complex listbox expression

Here is a sample app.

If someone could help I would be grateful.

Highlighted
MVP
MVP

Re: Re: Re: Complex listbox expression

Maybe like this?

Highlighted
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

Highlighted
MVP
MVP

Re: Re: Complex listbox expression

This should do the trick.

View solution in original post

Highlighted
Not applicable

Re: Complex listbox expression

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