Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

zhaohaifeng
New Contributor III

Sort for GetFieldSelections() dimension

Dear all,

As we want to used GetFieldSelections() fuction to judge the dimension, but if we used GetFieldSelections(), for sort we used the specific field, it's not useful.

As per test, if we used the specific field in the dimension the sort works. So all, who can help me how to set sort for GetFieldSelections() fuction.

Sort not works :

Dimension:

=Pick(Match(GetFieldSelections(Periods),'Quarter','MAT','Monthly','YTD'),

YearQtr,

[Y e a r],

YearMonth,

null()

)

Sort:

if(GetFieldSelections(Periods)='Qtr',YearQtr,if(GetFieldSelections(Periods)='MAT',[Y e a r],

IF(GetFieldSelections(Periods)='Monthly',YearMonth)))

Sort work:

Dimension:

YearMonth

Sort:

Sort:

if(GetFieldSelections(Periods)='Qtr',YearQtr,if(GetFieldSelections(Periods)='MAT',[Y e a r],

IF(GetFieldSelections(Periods)='Monthly',YearMonth)))