Pick(Match does not work for YearMonth field ?

[paulyeo11]

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

[jonathandienst]

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.

[paulyeo11]

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

[jonathandienst]

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