topic Re: Select expression values in QlikView

Select expression values

simonagheo — Wed, 25 Nov 2020 16:16:04 GMT

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 — Thu, 25 Aug 2016 09:27:52 GMT

Hi Simona,

see attachment.

Regards,

Antonio

effinty2112 — Thu, 25 Aug 2016 09:51:50 GMT

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 — Thu, 25 Aug 2016 11:32:22 GMT

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