topic Re: Show different values in ListBox in QlikView

Show different values in ListBox

Fri, 12 Jul 2013 10:21:33 GMT

Hello,

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:

[Polarity]:
LOAD * INLINE [
 Polarity
 MutationValue = {">0"}
 MutationValue = {"<0"} 
];

Fri, 12 Jul 2013 12:21:18 GMT

up aand up

Gysbert_Wassenaar — Fri, 12 Jul 2013 12:58:01 GMT

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

Anonymous — Fri, 12 Jul 2013 13:19:36 GMT

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