topic Re: Need resident load help in QlikView

Need resident load help

Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I need to load SalesREP ID whose current sales value for the current month is >0, but for last 8 years's sales value will be 0.

So I have written the below code in script:

[TmpSalesRep]:

first 2

load

[%Sales Trn Key],

[Process Date] as DateKey,

[Sales Amount USD] as SalesAmount,

[Sales Rep ID] as AsOfSalesRepID

resident [TmpTable]

where

[Process Month] = 'March' and [Sales Amount USD]>0;

left join

load

[%Sales Trn Key],

[Process Date] as DateKey,

[Sales Amount USD] as SalesAmount,

[Sales Rep ID] as AsOfSalesRepID

resident [TmpTable]

where

[Process Date] >= '$(vPrevEightYearStartDate)' and

[Process Date] <= '$(vPrevYearEndDate)' and

[Sales Amount USD]>=0;

//$(vCurrentMonth)

drop table [TmpTable];

Please let me know if I am wrong because I am getting wrong data.

Re: Need resident load help

kaushiknsolanki — Wed, 03 May 2017 08:35:09 GMT

Check link below.

need resident load help

Regards,

Kaushik Solanki

Re: Need resident load help

mato32188 — Wed, 03 May 2017 09:59:39 GMT

Hi Sandip,

instead of left join try to use concatenate.

BR

Martin