topic Re: Set Analysis (or fixed filter) on Dimension in App Development

Set Analysis (or fixed filter) on Dimension

bing_jville — Sun, 10 Mar 2019 19:10:10 GMT

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

Re: Set Analysis (or fixed filter) on Dimension

sergio0592 — Sun, 10 Mar 2019 19:44:16 GMT

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.

Re: Set Analysis (or fixed filter) on Dimension

bing_jville — Sun, 10 Mar 2019 21:35:46 GMT

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

Re: Set Analysis (or fixed filter) on Dimension

bing_jville — Sun, 10 Mar 2019 21:40:21 GMT

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

Re: Set Analysis (or fixed filter) on Dimension

NZFei — Sun, 10 Mar 2019 23:39:12 GMT

Dimension: Car;

Expression:

if(Price>100000,
Price
)

Re: Set Analysis (or fixed filter) on Dimension

bing_jville — Mon, 11 Mar 2019 02:26:04 GMT

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.