topic Re: Variable using quotes (") is not working when loaded in QlikView

Variable using quotes (") is not working when loaded

zagzebski — Wed, 23 Sep 2015 19:04:49 GMT

I am trying to get the variable to load correctly but I am having issues with quotes. I tried to use chr(34) but no success. chr(39) worked fine for apostrophes but can't figure out how to write variable so set expressions work for quotes.

VARIABLE:

vClaimsPYImpSiteMetroNoOther = '(sum({$ <
      [MI Imp Site Metro Regional DVC] = {"*"}-{'&Chr(39) & 'Other' &Ch(39) & '},
      [Incurred Year Month] = {"<=$(=Max([Incurred Year Month]-100))"},
      [Incurred Year] = {"$(=Max([Incurred Year]-1))"},
      [Paid YearMonth] = {"<=$(=Max([Paid YearMonth]-101))"}
>} [Claim Amt Allowed]))';

RESULT:

sum({$ <
[MI Imp Site Metro Regional DVC] = {"*"}-{'Other'}
[Incurred Year Month] = {"<="},
[Incurred Year] = {""},
[Paid YearMonth] = {"<="}
>} [Claim Amt Allowed]))

Thanks in advance,

Zag

Re: Variable using quotes (") is not working when loaded

lironbaram — Wed, 23 Sep 2015 19:10:17 GMT

not really clear what you want to achieve

what is the expected result you are after ?

Re: Variable using quotes (") is not working when loaded

zagzebski — Wed, 23 Sep 2015 19:14:08 GMT

Liron -

basically this part of the variable needs to stay the same...

[Incurred Year Month] = {"<=$(=Max([Incurred Year Month]-100))"},

[Incurred Year] = {"$(=Max([Incurred Year]-1))"},

[Paid YearMonth] = {"<=$(=Max([Paid YearMonth]-101))"}

but when loaded looks like this...

[Incurred Year Month] = {"<="},

[Incurred Year] = {""},

[Paid YearMonth] = {"<="}

Re: Variable using quotes (") is not working when loaded

maxgro — Wed, 23 Sep 2015 19:25:02 GMT

let vClaimsPYImpSiteMetroNoOther =

'sum({$ <

[MI Imp Site Metro Regional DVC] = {"*"}-{Other},

[Incurred Year Month] = {"<=' & chr(36) & '(=Max([Incurred Year Month]-100))"},

[Incurred Year] = {"' & chr(36) & '(=Max([Incurred Year]-1))"},

[Paid YearMonth] = {"<=' & chr(36) & '(=Max([Paid YearMonth]-101))"}

>} [Claim Amt Allowed])';

result is (ctrl+alt+V)

sum({$ <

[MI Imp Site Metro Regional DVC] = {"*"}-{Other},

[Incurred Year Month] = {"<=$(=Max([Incurred Year Month]-100))"},

[Incurred Year] = {"$(=Max([Incurred Year]-1))"},

[Paid YearMonth] = {"<=$(=Max([Paid YearMonth]-101))"}

>} [Claim Amt Allowed])

Re: Variable using quotes (") is not working when loaded

zagzebski — Wed, 23 Sep 2015 19:54:19 GMT

THanks! Although not sure why it worked. chr(36) is for the "$" sign. Why does that make it work?

Again - much apppreciated,

Zag

Re: Variable using quotes (") is not working when loaded

zagzebski — Wed, 23 Sep 2015 20:08:07 GMT

dumb question - I understand now.

Thanks.