topic Filtering a table based on a calculated field in QlikView

Filtering a table based on a calculated field

Mon, 08 Aug 2011 13:53:41 GMT

I have a table e.g.

Engineer	Subject	Created	Days
Engineer Name	Document explaining how to	18/04/2011	27
Engineer Name	report on	27/07/2011	4
Engineer Name	Status Refresh	07/06/2011	1

The "Days" column is a calculated field

I have created a new input box on the Sheet and assign the value entered to the variable $DaysSinceLastUpdate

I would like to filter the rows displayed in the table so that only the rows with a value in the "Days" column that matches the value in the variable $DaysSinceLastUpdate are displayed

So if I entered "4" in my input box the only row displayed in the table would be

Engineer	Subject	Created	Days
Engineer Name	report on	27/07/2011	4

Filtering a table based on a calculated field

villafuerte — Mon, 08 Aug 2011 14:00:45 GMT

Hi,

Maybe you can use Set Analysis in your expression:

{$<Days={$(DaysSinceLastUpdate)}>}

Re: Filtering a table based on a calculated field

Mon, 08 Aug 2011 18:36:49 GMT

Hi Mark,

See attached file for an example of set analysis, like Villafuerte said. Only, I'm doing =sum(...) instead.

Hope this helps,

Siarhei K.

Re: Filtering a table based on a calculated field

Tue, 09 Aug 2011 09:34:25 GMT

Thank you for the template but I'm using the personal edition also and I'm worried if I import any more qvw files that I won't be able to use it any more.

I haven't use set analysis before...I'll pay around with this a bit more and see if I can get it to work.

Re: Filtering a table based on a calculated field

Tue, 09 Aug 2011 09:35:27 GMT

Thank you for the template but I'm using the personal edition also and I'm worried if I import any more qvw files that I won't be able to use it any more.

I haven't use set analysis before...I'll pay around with this a bit more and see if I can get it to work.

Re: Filtering a table based on a calculated field

Tue, 09 Aug 2011 13:06:39 GMT

Oh, no problem.

Here's the expression for a table that I think would do what you need:

=sum({$<Days={'$(DaysSinceLastUpdate)'}>} Days)