Use Uppercase() in a calculated dimension in a Pivot-Table

[#1]

Is there a method to obtain the uppercase of some field in a calculated dimension in a pivot table ? I would like more precisely to use uppercase() in a match + pick:

=pick(match(UPPERCASE(Month), "JAN", "FEB"), "1", "2")

Is there a way ? Is the above possible?

Thanks in advance

[tresesco · Accepted solution]

Use single quotes rather than double, and upper()  like:

=pick(match(UPPER(Month), 'JAN', 'FEB'), '1', '2')

[Anonymous]

Hi,

In qlikview we have Upper() function not Uppercase() function and I would say this is more precise way to use Upper() function in your scenario.