Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Specialist
Specialist

Script Logic

Was wondering if I could have another set of eyes take a look at this logic.

CostCenterGroupHierarchy:
LOAD
NodeIDCostCenterName,
CostCenterGroupTemp AS [Profit Center],
CostCenterGroupDescriptionTemp AS [PC Desc],
if(NodeIDCostCenterName = 'RZ00000000' or
NodeIDCostCenterName = 'R120000000' or
NodeIDCostCenterName = 'R121000000' or
NodeIDCostCenterName = 'R122000000' or
NodeIDCostCenterName = 'R191000000',1,0) as NOGood
RESIDENT
[SETLEAF.CostCenterGroup]
WHERE
CostCenterGroupTemp >= [SETLEAF.From value_VALFROM] AND
CostCenterGroupTemp <= [SETLEAF.To value_VALTO] AND exists (NodeIDCostCenterName)
;
 
DROP TABLE [SETLEAF.CostCenterGroup];


When I check my NOGood switch here it's correct.


CostCenterGroup:
LOAD
NodeIDCostCenterName,
[Profit Center],
[PC Desc],
NOGood
RESIDENT
CostCenterGroupHierarchy
WHERE
NOGood = '0'
;
Drop Table CostCenterGroupHierarchy;

When I check it here it does not even exist in the table.....any ideas.

Thanks


//Rename Table Temp to CostCenterGroupHierarchy;
exit Script;

Labels (1)
1 Solution

Accepted Solutions
Highlighted
Specialist
Specialist

Never mind I found it.....missing (NoConcatenate)

View solution in original post

1 Reply
Highlighted
Specialist
Specialist

Never mind I found it.....missing (NoConcatenate)

View solution in original post