How to use filter condition in document level and object level

[#1]

Hi,

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

How can I filer records in Table box objects ?

Regards,

Ananth

[#2]

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.

[#3]

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.

[#4]

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

[IAMDV]

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,

DV

www.QlikShare.com

[#6]

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

[IAMDV]

Gerrit,

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

Cheers,

DV

QlikView Videos : www.QlikShare.com

[#8]

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 .