Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Condition in set analysis

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

Tags (1)
1 Reply
Not applicable

Condition in set analysis

Hi,

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

Thanks,

Robinson

Community Browser