Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

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"}

];

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
mov
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)

Regards,
Michael

Community Browser