Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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

1 Solution

Accepted Solutions
swuehl
MVP
MVP

This should do the trick.

View solution in original post

6 Replies
Not applicable
Author

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

Please provide the qvw with scrambling the data.

Not applicable
Author

Here is a sample app.

If someone could help I would be grateful.

swuehl
MVP
MVP

Maybe like this?

Not applicable
Author

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
MVP
MVP

This should do the trick.

Not applicable
Author

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