Filter on a calculated Value

[#1]

Hello,

I would like to be able to filter on a calculated value (like the monthly revenue for example).

I have all sort of charts and I would like to see appearing only the customers Which monthly income is superior to a certain value.

Customer	Monthly income
Customer 1	10000€
Customer 2	20000€
Customer 3	500€

I would like to be able to select only customer 1 and 2 (revenue above 1000€)

This sound basic but I'm stuck

[ramasaisaksoft]

Hi Martin,

select "straight table chart"

take the "customer" field in dimensions

expression:-if(Amount>1000,Amount)

i hope it will work

[Colin-Albert]

You can use dimension limits to restrict the customers.

QlikView 11 Dimension Limit Functionality