topic How to filter table to display just one row. in QlikView

How to filter table to display just one row.

Mon, 06 Jun 2011 22:31:54 GMT

In the attached sample I have a table which has five rows. I am trying to figure out how to create a table that filters out the five rows to a single row which is represented by column "A" the wellname. Example want to be able to create five charts that represent each individual row.

Help with filtering by a row.

Anonymous — Tue, 07 Jun 2011 01:29:34 GMT

Hi,

One approach would be to hard code the value using set analysis:

sum({$<Wellname={"Cyclone CJ"}>} BOPD)

..or whatever you want to sum up

How to filter table to display just one row.

Tue, 07 Jun 2011 01:42:13 GMT

Thank you for the quick response. Can you attach an example of the set analysis example. I tried in test.qvw but could not get it to work.

Re: How to filter table to display just one row.

Anonymous — Tue, 07 Jun 2011 01:44:56 GMT

Sure, ok. It's a straight forward Copy/Paste. Here you go!

Re: How to filter table to display just one row.

Tue, 07 Jun 2011 01:48:26 GMT

Thank you very much!