topic Resolving two vars side-by-side in QlikView

Resolving two vars side-by-side

Fri, 24 Sep 2010 01:27:03 GMT

How can I resolve two variables: "$(Topic)$(Subject) " side-by-side? I have created a nested For ... Next... loop... . I get an error message and it looks like QV only resolves the 1st one and ignores the other...

Actual Code is:

For each Topic in 'NP' ,'SS'

For each Subject in Math, Reading, Total, Writing

PSAT:
Load
SetID&'-'&num(StudentCode) as KeyfromStudentEW, //PK for entire PA Edmonds App
$(Topic)$(Subject) as PSATScaleScore,
'$(Topic) $(Subject)' as PSATSubjectTemp
Resident PSATTemp
;

Next Subject

Next Topic

Thanks,

Stephanie

Resolving two vars side-by-side

Miguel_Angel_Baeyens — Fri, 24 Sep 2010 07:06:16 GMT

Hello Stephanie,

Your second for each line should read

For each Subject in 'Math', 'Reading', 'Total', 'Writing'

All text values must be enclosed in quotes, so it has

'$(Topic)$(Subject)' as PSATSubjectTemp

Because "$(Topic)$(Subject)" is not a name of a field, but a text value. Apart from that, your code seems correct to me.

Regards.

Resolving two vars side-by-side

Fri, 24 Sep 2010 17:10:35 GMT

Thank you very much. Can't believe i missed the single quotes for the one "For next" statements... good catch.

Thanks for your response.... my code now works !

Thanks,

Stephanie Lind