Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
hi ,
just use
=if(len(Link)>0,ID)
as calculated dimension it works!!
find attachement eee.qvw
Warm Regards,
Anant Dubey
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
Still no use.
hi ,
just use
=if(len(Link)>0,ID)
as calculated dimension it works!!
find attachement eee.qvw
Warm Regards,
Anant Dubey
Ya it's working.