topic How to use filter condition in document level and object level in QlikView

How to use filter condition in document level and object level

Fri, 11 Jun 2010 11:42:44 GMT

Hi,

How can I filter a table to show only certain records?

How can I filer records in Table box objects ?

Regards,

Ananth

How to use filter condition in document level and object level

Fri, 11 Jun 2010 11:56:15 GMT

Filters are applied in QlikView against every object simply by "Selecting" records, so, as an example, you could create a list box that shows a certain field that you want to filter by, in this list box just click on the value(s) you wish to filter and the table/table box/chart will automatically reduce its contents to show you what you have filtered.

The same thing applies in the table box and in any other object, you could be lookin at a full dataset in the table but can then click on a certain value and the table will reduce according to that filter.

How to use filter condition in document level and object level

Tue, 31 May 2011 14:59:36 GMT

I believed the question is how to implement filtering on table-box without user intervention. In other words the initial display should NOT contain all data. I have the same question as well.

Re: How to use filter condition in document level and object level

Sat, 21 Jul 2012 21:56:21 GMT

Hi,

The same question for me,

I want to show all records in a table box except where the value in the field [status] has a value of 0.

How to achieve this?

Regards,

Gerrit

Re: How to use filter condition in document level and object level

IAMDV — Sun, 22 Jul 2012 07:21:57 GMT

If you wanted the subset of the data without initital selections then please use the straight table and you can mimic the formatting as TableBox. Is there a reason why you wanted to use TableBox instead of Straight Table?

Thanks,

www.QlikShare.com

Re: How to use filter condition in document level and object level

Sun, 22 Jul 2012 20:20:03 GMT

Deepak,

I use a Straight Table now and it works fine, thanks.

As I am a newbee my first thought was to use a TableBox because I have to show a table.

Will not happen again .

Regards,

Gerrit

Re: How to use filter condition in document level and object level

IAMDV — Sun, 22 Jul 2012 20:26:43 GMT

Gerrit,

You are welcome. I'm sure I had similar questions when I started using QV. Happy learning.

Cheers,

QlikView Videos : www.QlikShare.com

Re: How to use filter condition in document level and object level

Mon, 23 Jul 2012 18:41:36 GMT

I have a table box with athletes name height weight etc.

I have input box with variable Wt_input.

How do I set the filter in the table box for weight >= Weight_inp .