Issue with a NULL value

Sat, 09 Jun 2012 08:46:07 GMT

Hi,

I am having an issue that I am unable to resolve and am hoping someone could help me.

In the attached document, Sup.qvw, On tab Sheet 10, when I filter on Location Code ->OCDAM, I get [Resp Centre] values as NULL and WAHAROA.

However, it should not be returning any NULL.

In the load script, on Transaction tab, when I comment out the script where we concatenate the Sales Transaction table with TempSalesForecast table and reload the script, the Location Code OCDAM returns only WAHAROA (which is correct).

However, when I uncomment it, it seems to be returning both NULL and WAHAROA for Location Code OCDAM. If I copy the LOAD statement commented out above into a separate qvw (Test.qvw) and run it, it seems to be returning only WAHAROA.

I dont understand where I am going wrong. I suspect its because of the mapping load I use to look up [Resp Centre] in the load script

Can someone plz help.

Issue with a NULL value

Sun, 10 Jun 2012 05:56:05 GMT

Anybody??

Issue with a NULL value

deepakk — Sun, 10 Jun 2012 12:03:38 GMT

hi Sandeep,

try using the left join instead of Apply map for adding Resp Centre to SalesTransaction1

Deepak

Issue with a NULL value

Sun, 10 Jun 2012 22:12:39 GMT

Thx Deepak. Tried that and didnt work.

topic Issue with a NULL value in QlikView

Issue with a NULL value

Issue with a NULL value

Issue with a NULL value

Issue with a NULL value