Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone,
Someone can help me please?
How can I do, if we have "IsNull" + select?
Here is my request :
ISNULL((SELECT TA.TBL_LIB FROM TABLES TA WHERE TA.TBL_ID = 'FA4' AND TA.TBL_CODE = A.FA4_CODE), '') AS 'C4 Article',
How i can handle the NULL values and remove them on Qlikview?
what's the NULL handling in the Qlikview?
how can i use IsNull Individually to the fields and then use your expression?
I would like to convert this Sql request in into Qlikview
Thank you to all.
Regards
Read this document for NULL handling and for your expresion
I try this
C4 Article:
Load
If(ISNULL( TBL_LIB ),'',TBL_LIB) AS TBL_LIB
If(ISNULL( TBL_CODE ), '', TBL_CODE) AS TBL_CODE
From TableNameHere
Where TBL_ID = 'FA4'
Inner Join
Load
FA4_CODE
From TableNameHere
Hope this helps
Anand