topic Re: Datamodel in QlikView

Datamodel

Mon, 29 Jun 2015 13:04:44 GMT

I have two table primary sales and secondary purchase and a master table. I have to fetch all the invoice no which present in master and primary but not in secondary purchase.

PFA of invoice no. in primary sales and secondary purchase

Re: Datamodel

jonathandienst — Mon, 29 Jun 2015 13:25:03 GMT

That file is a bit large to download. I suggest that you look here:

Preparing examples for Upload - Reduction and Data Scrambling

Re: Datamodel

avinashelite — Mon, 29 Jun 2015 13:27:39 GMT

try like this:

Mater:

Load master_invoice,

Primary:

Load Primary_Invoice,

Temp:

Load master_invoice as Invoice

resident

Mater;

Load Primary_Invoice as Invoice

resident

Mater;

Secondary:

Load Secondary_invoice,

where 1=if(not exists(Invoice,Secondary_invoice)='-1',1,0);

this will give you the result

Re: Datamodel

Tue, 30 Jun 2015 12:54:37 GMT

it will give the same output for exclude and overall

Re: Datamodel

Wed, 01 Jul 2015 05:37:35 GMT

any suggestion

Re: Datamodel

avinashelite — Wed, 01 Jul 2015 10:42:45 GMT

Hi Shweta,

According to your requirement "I have to fetch all the invoice no which present in master and primary but not in secondary purchase." this will work rite?

can you please share the sample data or eg if the output your expecting to achieve

Re: Datamodel

Thu, 02 Jul 2015 06:42:32 GMT

i write this query but don't work for me

Re: Datamodel

Thu, 02 Jul 2015 06:51:37 GMT

PFA of data model and output for the same. value repeated for adirace inv no table

Re: Datamodel

avinashelite — Thu, 02 Jul 2015 07:34:56 GMT

try like this in the last table:

FROM
D:\QlikView\Secondary\Stage3\QVD\Purchase.QVD
(qvd)Where 1=if(Exists(INVOICE_NO,AdiraceInvNo)=’-1’,1,0) and Bill_No like 'PD*';