topic Re: Logic Problem in QlikView

Logic Problem

tmumaw — Fri, 29 May 2015 11:52:22 GMT

Does anyone see anything wrong with this logic? The CostCenterGroupHierarchy should only have records where RegionID is equal to '1'. I am getting nothing.

thanks

Left Join (Temp)
LOAD [Profit Center],
Region
FROM
[\\kent\datastore\DaveyData\IT Projects\Qlikview\Safety\Safety Regions.xls]
(biff, embedded labels, table is Sheet1$);

Temp1:
Load *,
if(len(trim(Region)) > 0,'1','0') as RegionID
Resident Temp;
Drop table Temp;

CostCenterGroupHierarchy:
Load *
Resident Temp1
Where RegionID = '1'
;
Drop table Temp1;
exit Script;

Re: Logic Problem

giakoum — Fri, 29 May 2015 11:55:17 GMT

temp1 and cost centergroupghierarchy are auto concatenated because they have the same fields

and then dropped...

Re: Logic Problem

danieloberbilli — Fri, 29 May 2015 11:55:29 GMT

Please note that you have an Exit script before your last load.

And I think you might need a 'NoConcatenate' in the last load - else it could be dropped

CostCenterGroupHierarchy:
NoConcatenate Load *
Resident Temp1
Where RegionID = '1'
;
Drop table Temp1;
exit Script;

Re: Logic Problem

m_woolf — Fri, 29 May 2015 11:56:41 GMT

The CostCenterGroupHierarchy load should say:

Noconcatenate Load *

Re: Logic Problem

Fri, 29 May 2015 12:01:34 GMT

Hi Thom,

You should use non-concatenation.

Ramaya

Re: Logic Problem

Gabriel — Fri, 29 May 2015 12:09:10 GMT

Hi,

In your WHERE clause just say

WHERE RegionID = 1; // See below

Re: Logic Problem

tmumaw — Fri, 29 May 2015 12:17:37 GMT

Thanks everyone. It works perfect.

Re: Logic Problem

Gabriel — Fri, 29 May 2015 12:19:55 GMT

Hi,

Am glad that worked