Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Show different values in ListBox

Hello,

I have the following ListBox to show values that are greater than 0 or smaller.

naamloos.JPG

Now, I want to use this to give the user the ability to filter the MutationValue. So I want to show it in the interface.

But is there a possibility to show 'Mutation Value > 0' instead of 'MutationValue = {">0"}' ?

Cause its pretty ugly from a designer perspective.

I use the following code to create this little table:

[Polarity]:

LOAD * INLINE [

Polarity

MutationValue = {">0"}

MutationValue = {"<0"}

];

3 Replies
Not applicable
Author

up aand up

Gysbert_Wassenaar

Perhaps the example in this discussion is what you're looking for.


talk is cheap, supply exceeds demand
Anonymous
Not applicable
Author

There is no need to create anything in the script.  Use calculated list box with expression:

=aggr(if(MutationValue>0, 'Mutation Value >0', if(MutationValue<0, 'Mutation Value <0')), MutationValue)

Regards,
Michael