Value range

[danielnevitt]

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

[swuehl · Accepted solution]

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)

[danielnevitt]

Thank you for your help.  That solution works perfectly.

Regards,

Daniel