topic Re: Filtering out data in Straight Table in QlikView

Filtering out data in Straight Table

Mon, 03 Sep 2012 10:59:50 GMT

I have a straight table with a load of data in it. How would I add a filter so that I only see rows where a value in one of the columns is > 100, for example?

Re: Filtering out data in Straight Table

jonathandienst — Mon, 03 Sep 2012 11:02:54 GMT

You have a number of options open to you:

If the amount is fixed, then you could add a flag in your load script and then filter on the flag.
If the amount can be one of only a few values, you could create intervals for these values and then intervalmatch the intervals. Then filter on the intervals (depending on user selections).
You may be able to apply a filter to one or more of the dimensions (by using a calculated dimension).
You can filter the data columns (you must do this to all the columns). Lets say the value of interest is in Column 1:

=If(expression1 > 100, expression1)

=If(Column(1) > 100, expression2)

=If(Column(1) > 100, expression3)

=If(Column(1) > 100, expression4)

....

(oh, and ensure that suppress null values is ON)

There may be others. Without more information on your requirements, its hard to be specific.

Hope that helps

Jonathan

Re: Filtering out data in Straight Table

Mon, 03 Sep 2012 14:02:45 GMT

Hi,

Thanks for taking the time to respond, really appreciate it. Options 1 and 2 aren't suitable. How would I filter the data using a calculated dimension? Giving a bit more detail, I have a table containing an ID number, the date it was added to the database and the time difference between the date added and now.

What I want to do is only show rows where the difference in seconds is greater than 540,000. I have a calculated expression called 'M_Seconds' that contains this value for each row, but if I do IF(now - logdate > 540000, now - logdate) on the expression then it doesn't actually filter anything out.

Re: Filtering out data in Straight Table

Mon, 03 Sep 2012 14:07:32 GMT

I figured it out I think, I found the Calculated Dimension option and set that to my expression, then suppressed NULL values and it has filtered the data out. Thanks!

Re: Filtering out data in Straight Table

Wed, 14 May 2014 09:28:09 GMT

Thanks,

this Helps me also...

Re: Filtering out data in Straight Table

Anonymous — Tue, 26 Aug 2014 16:20:06 GMT

Helps me too.