topic Suppress when there is null in expression in QlikView

Suppress when there is null in expression

Thu, 29 Mar 2012 07:35:07 GMT

Hello,

I've loaded the below data in qvw file

LOAD * INLINE [

ID, Link

1, A.bmp

2, B.bmp

3,

4

5, C.bmp

6, D.bmp

];

- In Straight table i've taken dimension as ID and Expression as =Link &'<URL>WWW.Google.com'.

So i can able to see in front as below image.

- Now i want to Suppress the table if the expression is null.

Suppress when there is null in expression

CELAMBARASAN — Thu, 29 Mar 2012 07:42:46 GMT

Hi,

Load the values like this because while loading in inline it assumes it as empty value(like '') not as null.

LOAD ID,if(len(Link)>0,Link,Null()) as Link INLINE [

ID, Link

1, A.bmp

2, B.bmp

3

4

5, C.bmp

6, D.bmp

];

Then Check suppress null values in the dimension tab.

Celambarasan

Suppress when there is null in expression

Thu, 29 Mar 2012 08:16:41 GMT

Still no use.

Re: Suppress when there is null in expression

Thu, 29 Mar 2012 08:49:55 GMT

hi ,

just use

=if(len(Link)>0,ID)

as calculated dimension it works!!

find attachement eee.qvw

Warm Regards,

Anant Dubey

Suppress when there is null in expression

Thu, 29 Mar 2012 08:57:40 GMT

Ya it's working.