IsNull, Select, Remove Null Values

[#1]

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

[ashfaq_haseeb]

Hi,

Check this for better understanding.

NULL handling in QlikView

Regards

ASHFAQ

[its_anandrjs]

Read this document for NULL handling and for your expresion

NULL handling in QlikView

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