Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

paulyeo11
Valued Contributor II

Pick(Match does not work for YearMonth field ?

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)

YearMonth.png

it there any work around ?

Paul

3 Replies
MVP
MVP

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

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
Valued Contributor II

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

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

MVP
MVP

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

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