Only show rows above given threshold?

richnorris — Thu, 16 Aug 2012 16:45:46 GMT

Hi, what I'm trying to do seems simple to me, but I just can't seem to wrap my head round it.

I have a number of dimensions, related to a trade, eg client, client type, currency etc. I have a number of expressions which are all of the format

SUM(metric)*$(vEx)

where vEx is a variable holding the exchange rate.

What I want to do is, have a dropdown or input box, where a user puts in a value (or selects a value) storing it into a variable (vThreshold) and then the chart updates to only show rows where the

SUM([$ TV])*$(vEx) >= $(vThreshold)

If I do something like IF(SUM(metric)*$(vEx) >= $(vThreshold), SUM(metric)*$(vEx)) then it gives me nulls for the rows that dont meet the requirement. I need some sort of set analysis so that it doesn't show those rows at all, but I just cant work out any kind of way of doing that?

Re: Only show rows above given threshold?

Thu, 16 Aug 2012 17:09:01 GMT

Rich,

The expression you have is correct. Just go to presentation tab in chart properties and check "supress null values".

Kiran.

topic Only show rows above given threshold? in QlikView

Only show rows above given threshold?

Re: Only show rows above given threshold?