topic Re: Value range in QlikView

Value range

danielnevitt — Thu, 01 May 2014 10:14:41 GMT

Hi,

I am trying to create an input value range to allow our users to only see data between a specified vMin and vMax range.

For example:

vMin = -1,500

vMax = 1,500

The data shown in the straight table should only have an AMOUNT (field name) between this range.

I tried to use a slider, however my range of value is between -300,000,000.00 and 500,000,000.00, therefore I was unable to select a anything less than a few million.

Any help would be much appreciated.

Thanks,

Daniel

Re: Value range

swuehl — Thu, 01 May 2014 10:20:00 GMT

Try an expression like

=sum({<AMOUNT = {">=$(vMin)<=$(vMax)"}>} AMOUNT)

if you have a dimension like Customer, and you want to show only Customers with a aggregated AMOUNT between the range, you need to write

=sum({<Customer = {"=sum(AMOUNT) >=$(vMin) and sum(AMOUNT) <=$(vMax)"}>} AMOUNT)

Re: Value range

danielnevitt — Thu, 01 May 2014 10:29:05 GMT

Thank you for your help. That solution works perfectly.

Regards,

Daniel