Condition in set analysis

Tue, 15 May 2012 06:09:22 GMT

Hi,

Can you help?

I have variable Minimum Amount and Maximum...

What I want is that, I will only display items, with this condition

UnitPrice >= Minimum Amount and UnitPrice <= Maximum Amount

Here's my expression:

sum({<item_unit_price = {'>$(minAmount)'}>} SellOut)

HOW CAN I ADD THE MAXIMUM AMOUNT? Please extend help.

Best Regards,

Bill

Tue, 15 May 2012 07:03:37 GMT

Hi,

sum({<item_unit_price = {'>$(minAmount)'},UnitPrice={'<$(maxAmount)'}>} SellOut)

Thanks,

Robinson

topic Condition in set analysis in QlikView