topic Re: Use Uppercase() in a calculated dimension in a Pivot-Table in QlikView

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

Fri, 11 Jul 2014 09:46:49 GMT

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

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

tresB — Fri, 11 Jul 2014 09:51:13 GMT

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

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

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

Anonymous — Fri, 11 Jul 2014 09:53:42 GMT

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.