topic Re: Syntax issue in QlikView

Syntax issue

tmumaw — Thu, 22 Jan 2015 18:37:06 GMT

Help. What is wrong with the following.....

if(Quote_Cancelled = '1' and
(Opportunity.davey_HeaderCancelCode = '12' or
Opportunity.davey_HeaderCancelCode = '13' or
Opportunity.davey_HeaderCancelCode = '14' or
Opportunity.davey_HeaderCancelCode = '16'),0,1) as NoPrint,

Thanks

Re: Syntax issue

jerem1234 — Thu, 22 Jan 2015 18:41:57 GMT

Seems fine to me. You may be able to reduce the code a bit with:

if(Quote_Cancelled = '1' and match(Opportunity.davey_HeaderCancelCode, '12', '13', '14', '16'),0,1) as NoPrint,

Re: Syntax issue

Colin-Albert — Thu, 22 Jan 2015 19:00:38 GMT

Are you using this code in a chart or the script?

If in the script, are both fields in the same table that you are loading from?

Re: Syntax issue

tmumaw — Thu, 22 Jan 2015 19:04:23 GMT

Load script and yes both fields are in the same table.

Re: Syntax issue

jerem1234 — Thu, 22 Jan 2015 19:06:55 GMT

What error are you getting? and can you post the whole load statement? Might be something small like a comma where it shouldn't be or a missing semi-colon.

Re: Syntax issue

tmumaw — Thu, 22 Jan 2015 19:10:23 GMT

Opportunity:
Load *,
if(Len(Opportunity.Davey_SalesDocumentNumber) > 0 and Len(OpportunityLines) > 0,
Num(Opportunity.Davey_SalesDocumentNumber,'0000000000') & OpportunityLines) as %ContractItemKey,
if(Len(Opportunity.Davey_SalesDocumentNumber) = 0,'Q','R') as Status_R_Q,
if(Quote_Cancelled = '1' and Match(Opportunity.davey_HeaderCancelCode = '12','13','14','16'),0,1) as NoPrint

Resident Opportunity_Temp1
;
Drop Table Opportunity_Temp1;

This made everything a '1'

Re: Syntax issue

jerem1234 — Thu, 22 Jan 2015 19:24:03 GMT

Use this script:

Opportunity:
Load *,
if(Len(Opportunity.Davey_SalesDocumentNumber) > 0 and Len(OpportunityLines) > 0,
Num(Opportunity.Davey_SalesDocumentNumber,'0000000000') &OpportunityLines) as %ContractItemKey,
if(Len(Opportunity.Davey_SalesDocumentNumber) = 0,'Q','R') as Status_R_Q,
if(Quote_Cancelled ='1' and Match(Opportunity.davey_HeaderCancelCode,'12','13','14','16'),0,1) as NoPrint
Resident Opportunity_Temp1;

Drop Table Opportunity_Temp1;

Hope this helps!

Re: Syntax issue

tmumaw — Fri, 23 Jan 2015 15:39:43 GMT

Thanks Jeremiah....It worked perfectly.