topic Re: Avoiding blanks on table in QlikView

Avoiding blanks on table

NavinReddy — Wed, 29 Jun 2016 11:27:32 GMT

Dear Experts Good Afternoon,

I am trying to avoiding the blanks on straight table.

with this blanks on straight table the FACT numbers its repeating multiple time. Any way to avoiding

please suggest me

for reference i have attached the image

Thanks,

Niru

Re: Avoiding blanks on table

amit_saini — Wed, 29 Jun 2016 11:36:39 GMT

Hi,

Try to change this to Pivot table!

Thanks,
AS

Re: Avoiding blanks on table

Digvijay_Singh — Wed, 29 Jun 2016 11:57:55 GMT

Try these -

1. check 'Suppress When Value is null' in dimension tab

2.'Suppress missing and zero values in Presentation tab.

But out of many expression, even if one expression has value and others having null, that row will be shown.

Regards,

Re: Avoiding blanks on table

NavinReddy — Wed, 29 Jun 2016 18:53:11 GMT

Hi both the logics i have tried not worked

any other way to resolve this issue on script side

For only 3 fields, please suggest

Re: Avoiding blanks on table

maxgro — Wed, 29 Jun 2016 19:21:54 GMT

if your fields are in a single table, you can add a where condition to the load

to remove the rows where all the fields are null, something like (the fields are d1 d2 d3, replace with yours)

load

......

from

....

where len(trim(d1)) or len(trim(d2)) or len(trim(d3));

Re: Avoiding blanks on table

MarcoWedel — Wed, 29 Jun 2016 22:41:18 GMT

Hi,

as only ever one of your Risk, BD and Resource fields has a value, I suggest to review your data model.

hope this helps

regards

Marco

Re: Avoiding blanks on table

vikasmahajan — Thu, 30 Jun 2016 05:02:45 GMT

While loading script you can check dimension like this isnull(Risk) or len(Risk) = 0 as flag , and skip this records in set analysis.

Vikas

Re: Avoiding blanks on table

NavinReddy — Thu, 30 Jun 2016 09:34:52 GMT

Thank You its working