Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Hi Simona,
see attachment.
Regards,
Antonio
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
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