Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Show different values in ListBox


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


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:




MutationValue = {">0"}

MutationValue = {"<0"}


Tags (3)
3 Replies
Not applicable

Re: Show different values in ListBox

up aand up

Re: Show different values in ListBox

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

talk is cheap, supply exceeds demand
Esteemed Contributor III

Re: Show different values in ListBox

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)


Community Browser