topic Re: Calculated Dimension in Script in QlikView

Calculated Dimension in Script

cbaqir — Sat, 16 Nov 2024 20:14:20 GMT

This works as a calculated dimension but I can't get it to work in the script. It says Error: Error in expression:
')' expected. Any idea why?

if((subfield(GOV_DECISION_BODY,';')=PRIMARY_DECISION_BODY,date#(yearstart(PRIMARY_DECISION_AGENDA_DATE))
,if((subfield(GOV_DECISION_BODY,';')=PRIMARY_DECISION_BODY_COMMITTEE_CAT,date#(yearstart(PRIMARY_DECISION_AGENDA_DATE))
,if((subfield(GOV_DECISION_BODY,';')=SECONDARY_DECISION_BODY_COMMITTEE_CAT,date#(yearstart(SECONDARY_DECISION_AGENDA_DATE))
,if((subfield(GOV_DECISION_BODY,';')=SECONDARY_DECISION_BODY_COMMITTEE_CAT,date#(yearstart(SECONDARY_DECISION_AGENDA_DATE))
,if((subfield(GOV_DECISION_BODY,';')=THIRD_DECISION_BODY,date#(yearstart(THIRD_DECISION_AGENDA_DATE))
,if((subfield(GOV_DECISION_BODY,';')=THIRD_DECISION_BODY_COMMITTEE_CAT,date#(yearstart(THIRD_DECISION_AGENDA_DATE))
,if((subfield(GOV_DECISION_BODY,';')=FOURTH_DECISION_BODY_COMMITTEE_CAT,date#(yearstart(FOURTH_DECISION_AGENDA_DATE))
,if((subfield(GOV_DECISION_BODY,';')=FOURTH_DECISION_BODY_COMMITTEE_CAT,date#(yearstart(FOURTH_DECISION_AGENDA_DATE))
,if((subfield(GOV_DECISION_BODY,';')=FIFTH_DECISION_BODY_COMMITTEE_CAT,date#(yearstart(FIFTH_DECISION_AGENDA_DATE))
,if((subfield(GOV_DECISION_BODY,';')=FIFTH_DECISION_BODY_COMMITTEE_CAT,date#(yearstart(FIFTH_DECISION_AGENDA_DATE))
,if((subfield(GOV_DECISION_BODY,';')=SIXTH_DECISION_BODY_COMMITTEE_CAT,date#(yearstart(SIXTH_DECISION_AGENDA_DATE))
,if((subfield(GOV_DECISION_BODY,';')=SIXTH_DECISION_BODY_COMMITTEE_CAT,date#(yearstart(SIXTH_DECISION_AGENDA_DATE
)))))))))))))))))))))))))) as AGENDA_DATE_YEAR,

Re: Calculated Dimension in Script

Frank_Hartmann — Tue, 20 Aug 2019 15:27:08 GMT

Maybe this:

if(subfield(GOV_DECISION_BODY,';')=PRIMARY_DECISION_BODY,date#(yearstart(PRIMARY_DECISION_AGENDA_DATE)) ,if(subfield(GOV_DECISION_BODY,';')=PRIMARY_DECISION_BODY_COMMITTEE_CAT,date#(yearstart(PRIMARY_DECISION_AGENDA_DATE)) ,if(subfield(GOV_DECISION_BODY,';')=SECONDARY_DECISION_BODY_COMMITTEE_CAT,date#(yearstart(SECONDARY_DECISION_AGENDA_DATE)) ,if(subfield(GOV_DECISION_BODY,';')=SECONDARY_DECISION_BODY_COMMITTEE_CAT,date#(yearstart(SECONDARY_DECISION_AGENDA_DATE)) ,if(subfield(GOV_DECISION_BODY,';')=THIRD_DECISION_BODY,date#(yearstart(THIRD_DECISION_AGENDA_DATE)) ,if(subfield(GOV_DECISION_BODY,';')=THIRD_DECISION_BODY_COMMITTEE_CAT,date#(yearstart(THIRD_DECISION_AGENDA_DATE)) ,if(subfield(GOV_DECISION_BODY,';')=FOURTH_DECISION_BODY_COMMITTEE_CAT,date#(yearstart(FOURTH_DECISION_AGENDA_DATE)) ,if(subfield(GOV_DECISION_BODY,';')=FOURTH_DECISION_BODY_COMMITTEE_CAT,date#(yearstart(FOURTH_DECISION_AGENDA_DATE)) ,if(subfield(GOV_DECISION_BODY,';')=FIFTH_DECISION_BODY_COMMITTEE_CAT,date#(yearstart(FIFTH_DECISION_AGENDA_DATE)) ,if(subfield(GOV_DECISION_BODY,';')=FIFTH_DECISION_BODY_COMMITTEE_CAT,date#(yearstart(FIFTH_DECISION_AGENDA_DATE)) ,if(subfield(GOV_DECISION_BODY,';')=SIXTH_DECISION_BODY_COMMITTEE_CAT,date#(yearstart(SIXTH_DECISION_AGENDA_DATE)) ,if(subfield(GOV_DECISION_BODY,';')=SIXTH_DECISION_BODY_COMMITTEE_CAT,date#(yearstart(SIXTH_DECISION_AGENDA_DATE )))))))))))))) as AGENDA_DATE_YEAR,

Re: Calculated Dimension in Script

Or — Tue, 20 Aug 2019 15:27:16 GMT

Try removing the double parenthesis from each line (and the matching ones at the end). You don't need two, and the script engine doesn't seem to like it.