Joins

[#1]

Hi,

During the outer join for the rows which does not have the mtaching rows are displayed as '-' . i want to replace - with 0. i tried with if condition as below

but it is not working .please suggest

if(a='-' ,0 ,a )

[#2]

If I assume that you are having 2 qlikview tables A and B, adn you are if you are replacing null values in the edit script, you will not  have null values after loading data into qlikview. And if Qlikview is doing an outerjoin for presenting the data for you in an object, there can still be null values represented by '-' if there are mismatching records as per the joining column. These null values you can only handle as per the reply above by Kieran Boyce with screenshot.

[#3 · Accepted solution]

Thanks for everyone,

  Yes i was doing outerjoin and the missing values were need to converted to 0 and do the aggregation,

So i used the same if condition in the resident table and it is working fine

[schivet]

Hi,

The IsNull fonction is not always working properly.

I suggest you to use this instead directly in the laod of your data:

If( len(trim([Field A]))=0,'0',[Field A]) AS [Field A],

Regards

Stéphane

[sanketkhunte]

Hi All,

I would like to have word on this.

Such NULL check conditions should handle while pulling the data into Qlik View Data files from DB. I mean while we firing queries on Database. Try to make optimized code @ Qlikview data model layer which give super performance.

Hope this may help.

Thanks

Sanket