topic Re: Hi friends, How to do Less than in Set Analysis where a variable holds a value like this? in QlikView

Hi friends, How to do Less than in Set Analysis where a variable holds a value like this?

jblomqvist — Thu, 01 Sep 2016 14:30:24 GMT

Hi,

I have the following ProductID values:

I created a variable called vProductID

When I use it in Set Analysis it's like this:

=Sum({<ProductID={<=$(vMaxProductID)}>}LineSalesAmount)

But it gives me this error message:

Anybody know how I can get it to work please?

Anonymous — Thu, 01 Sep 2016 14:34:25 GMT

try this

=Sum({<ProductID={'<=$(vMaxProductID)'}>}LineSalesAmount)

sunny_talwar — Thu, 01 Sep 2016 14:36:09 GMT

Try one of these two:

=Sum({<ProductID={'<=$(=vMaxProductID)'}>}LineSalesAmount)

=Sum({<ProductID={'<=$(=$(vMaxProductID))'}>}LineSalesAmount)