Suppress when there is null in expression

[#1]

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.

[CELAMBARASAN]

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

[#3]

Still no use.

[#4 · Accepted solution]

hi ,

just use

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

as calculated dimension it works!!

find attachement  eee.qvw

Warm Regards,

Anant Dubey

[#5]

Ya it's working.