Set Analysis (or fixed filter) on Dimension

[bing_jville]

Hi Qlikies,

I have a straight table with car models. I only wan to show cars with price over $100k.

Car Price

CarA 90k

CarB 110k

CarC 105k

CarD 80K

I want to have the table title as "Cars over 100k", and only shows rows as cars over 100K in the table.

Can I do that? 

Thanks 

[sergio0592]

Hi,

As expression use :

sum({<Price={">100"}>} Price)

And remove k in your data. Let the just the sales amount. You can format your field after.

[bing_jville]

Thanks, but I don't want to do a SUM, just individual rows of each car

[bing_jville]

Thanks, but I don't want to do a SUM, just individual rows of each car

[NZFei · Accepted solution]

Dimension: Car;

Expression:

if(Price>100000,
Price
)

[bing_jville]

Thanks. I didn't design my question as I wanted. But I got a solution now.

I was trying to filter a table with something like "Count(SalesID)=0". So it is not set analysis on dimension, but using measure result as a filter.