Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
simonagheo
Contributor III
Contributor III

Select expression values

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!

3 Replies
antoniotiman
Master III
Master III

Hi Simona,

see attachment.

Regards,

Antonio

effinty2112
Master
Master

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
Contributor III
Contributor III
Author

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