topic Re: Nulls giving incorrect results. in QlikView

Nulls giving incorrect results.

kishorj1982 — Thu, 31 Aug 2017 09:00:19 GMT

Hi All,

PFA,

I have added nulls in table to handle drill down.But it is giving incorrect results. can you please suggest.

Thanks.

Re: Nulls giving incorrect results.

kishorj1982 — Thu, 31 Aug 2017 10:44:27 GMT

Hi All,

Could you please suggest on this.

Thanks

Re: Nulls giving incorrect results.

prma7799 — Thu, 31 Aug 2017 10:49:14 GMT

What is your expected output?

Re: Nulls giving incorrect results.

Anil_Babu_Samineni — Thu, 31 Aug 2017 11:06:58 GMT

Hello, Your explanation is not clear but you provided work file. If you explained where we are looking that would be Accuracy to reply

Re: Nulls giving incorrect results.

kishorj1982 — Thu, 31 Aug 2017 11:46:49 GMT

I have added results before adding null and results after adding nulls in two separate tables can you please suggest what is the exact issue why I am getting different sum for collection amount against same set of data in two different tables.

thanks

Re: Nulls giving incorrect results.

Anil_Babu_Samineni — Thu, 31 Aug 2017 12:03:04 GMT

May be add this in your second tab?

Re: Nulls giving incorrect results.

Anonymous — Thu, 31 Aug 2017 12:51:48 GMT

Hi,

In your script you suppress the duplication in the first table because you concatenate with a "load distinct" table

You should tri to add a counter in the first table like this :

lOAD

rowno() as ROW_ID,

CollectionAmount,

LOB,

COMPANYID,

FISCALYEAR,

Collection_Receipt_Date

FROM

Cash_Collection.qvd(qvd)

WHERE not Match(UPPER(TRIM(LOB)), 'IPWC','INTE','RETN','CC','MISC','UTAH','RENT','RETK','RETS','0008','') and COMPANYID<>'10134'

and

FISCALYEAR >= '2017'

and

year(Collection_Receipt_Date)>='2017' ;