topic Re: How to filter a table in QlikView

How to filter a table

Mon, 23 Mar 2015 14:36:10 GMT

Hello,

Actually, I have a table with empty cells and I only would like to show a table filled. I think it's impossible to make it with the script and I have to use the expression from the table himself.

Header 1	Header 2	Header 3
Group1
Group2	1	2
Group3	3	4

Header 1	Header 2	Header 3
Group2	1	2
Group3	3	4

I hope it is clear and if you need more precision I'll try to put more details.

Regard

Re: How to filter a table

awhitfield — Mon, 23 Mar 2015 14:46:09 GMT

Hi Kenny,

if it's a 'straight table' then tick 'supress Zero Values' on the presentation tab of the object properties

Andy

Re: How to filter a table

sunny_talwar — Mon, 23 Mar 2015 14:50:13 GMT

You can use what awhitfield just mentioned above or you can create a calculated dimension like this:

=If(not IsNull(Value1) and not IsNull(Value2), Dim)

this will remove the dimension where Value1 and Value2 are both null.

HTH

Best,

Re: How to filter a table

jonathandienst — Mon, 23 Mar 2015 14:50:40 GMT

Is this a table box or a straight table. You can suppress nulls by column in a table box.

If it is a straight table, and these fields are all dimension, click the suppress nulls on the dimensions dialog.

If it is a straight table, are the empty cells expressions that return nulls? If so, make sure that suppress zero values is checked. If the cells are empty strings, then you could modify the expressions to return nulls if the result would be an empty string, or create a calculated dimension that returns a null if the expression returns an empty string.

HTH

Jonathan

Re: How to filter a table

Anonymous — Mon, 23 Mar 2015 14:51:52 GMT

Go to presentation and check 'omit when value is null' for the respective fields

Re: How to filter a table

ashwanin — Mon, 23 Mar 2015 14:53:02 GMT

Hi ,

Its possible. You just need to remove blank .

It should be :

Table:

LOAD * INLINE [

Header_1, Header_2, Header_3

Group1, ,

Group2, 1, 2

Group3, 3, 4

] Where [Header_2] <> '';

Re: How to filter a table

Mon, 23 Mar 2015 14:57:14 GMT

Hello everyone,

I forgot to mention that's a table box. The table is just an example, the true table is a big one.

Thanks for your help, I made it!

Re: How to filter a table

sunny_talwar — Mon, 23 Mar 2015 15:00:32 GMT

So then you can use jontydkpi method.

Select Omit Rows Where Field is Null should do the trick for you.

Best,