topic Re: Problem with $ in Variable Definition in Script in QlikView

Problem with $ in Variable Definition in Script

azimabadi — Wed, 22 Aug 2012 06:52:29 GMT

Hi.

i define variables in my script. i read some data from excel fiels and construct my variables. but i have a problem wit $ in defination.

consider this :

SET yearString='Kalender.Jahr';
SET sumString = 'Field_a - Field_B';
LET mainString = '( sum ({<' &
  yearString & '={"' & '$' & '(=max(Kalender.Jahr)-' & n & ')"}>} ' &
  sumString & ' ))';

i need to get the following:

( sum ({<Kalender.Jahr={"$=max(Kalender.Jahr)-1"}>} Field_a - Field_B ))

insted the answer is:

( sum ({<Kalender.Jahr={"(internal error)"}>} Field_a - Field_B ))

what that is really intersting is that i used the same syntax in another qvw and it works as i expected.

Best Regards

Peyman

Re: Problem with $ in Variable Definition in Script

Anonymous — Wed, 22 Aug 2012 07:25:55 GMT

just tried your script to calculate the variables..

works perfectly well.. as your expected result..

Re: Problem with $ in Variable Definition in Script

azimabadi — Wed, 22 Aug 2012 07:29:58 GMT

as i said it works in one qvw and exactly same syntax gives me 'Internal Error'.

Re: Problem with $ in Variable Definition in Script

azimabadi — Wed, 22 Aug 2012 07:43:03 GMT

here i attach the example where i get 'Internal Error'.

Re: Problem with $ in Variable Definition in Script

Anonymous — Wed, 22 Aug 2012 10:15:52 GMT

pleace check attached..

hope that helps..