topic Re: Pick(Match does not work for YearMonth field ? in App Development

Pick(Match does not work for YearMonth field ?

paulyeo11 — Fri, 04 Sep 2015 05:03:55 GMT

Hi All

I am using the below diamension for chart , all work fine except YearMonth display as number :-

Pick(Match($(Var_P),1,2,3,4,5,6,7,8,9,10),year,Quarter,YearMonth,SEGMENT,SEGMENT_,REGION_,COUNTRY,GROUP_CLASS,company)

it there any work around ?

Paul

Re: Pick(Match does not work for YearMonth field ?

jonathandienst — Fri, 04 Sep 2015 05:11:33 GMT

Rather than using Pick(Match()), have you considered using a drill group or a cyclic group. Add all the dimensions fields to the group and use the group as the chart dimension. Use a drill group if there is a hierarchical relationship between the fields, or a cyclic if there is not.

Re: Pick(Match does not work for YearMonth field ?

paulyeo11 — Fri, 04 Sep 2015 06:37:35 GMT

Hi jonathan

Thank you vey much for the alternative , may i know does QS support cyclic group ?

I aware QV does have cyclic group. but not sure in QS.

Paul

Re: Pick(Match does not work for YearMonth field ?

jonathandienst — Fri, 04 Sep 2015 06:40:27 GMT

Perhaps not - I have not invested a lot of time on QS