topic Re: Hiding Row When field is null in QlikView

Hiding Row When field is null

Wed, 25 Nov 2020 16:16:04 GMT

Hi Folks,

i have a query.

is it possible to hide a full row if a column was null.if so kindly guide me

am using a table object.

kindly find the attached image for reference, the highlighted columns in the image are null and i want to remove the entire row against that

kindly help us to overcome on this.

thanks in Advance..

With Regards

DeepaK Subramoniam

Chanty4u — Fri, 08 Jul 2016 12:29:42 GMT

try to create one feild in script

Trim([sale]) as [sale1]

Chanty4u — Fri, 08 Jul 2016 12:31:18 GMT

chk dis

mightyqlikers — Fri, 08 Jul 2016 12:35:04 GMT

hi deepak,

take a straight table and use that field as dimension and supress when value is null in dimension tab of chart properties.

you will get it.

$@M.

sunny_talwar — Fri, 08 Jul 2016 12:35:58 GMT

Is this in a table box or straight table? If it is straight table, please provide information about your expressions and dimensions

boorgura — Fri, 08 Jul 2016 12:42:32 GMT

For Table box - you can set to OMIT the row in the 'presentation' tab of object properties.

Fri, 08 Jul 2016 13:19:07 GMT

tried but not working for me..

thanks in Advance..

WITH Regards

Deepak Subramoniam

Fri, 08 Jul 2016 13:20:24 GMT

tried that already

Thanks in Advance...

With regards

Deepak Subramoniam

boorgura — Fri, 08 Jul 2016 13:28:37 GMT

Can you please share a sample QVW?

Also - is it a NULL or just a '-' ?