Select expression values

[simonagheo]

Hello,

I created a straight table with a Total expression and another Check expression :

=if(Total<0,'Bad',If(Total>100,'Very good','Good')

Is there a way to make selections based on Check values?

I want to make a list box with 'Bad'/'Good'/'Very good' values and I need to be able to select only Bad or Good values.

Thanl you!

[antoniotiman]

Hi Simona,

see attachment.

Regards,

Antonio

[effinty2112]

Hi Simona,

                    You can do this using the Aggr function but we need to know what field you want to select on.

If you make a listbox with this expression:

Aggr(if(Total<0,'Bad',If(Total>100,'Very good','Good'), Dimension)

and in the new listbox you select 'Bad' then QlikView will select those values of the Dimension for which Total < 0.

Cheers

Andrew

[simonagheo]

Thank you, but this doesn't work for me because Total is an expression  based on some operations on different fields:

1 - Cost*Quantity/Value