use cyclic dimension in pick()

[bartwelvaarts]

hi community,

i want to use a cyclic dimension with the pick() function in a dimension. this way i show totals and dimension values. this works fine for a individual dimension. but it does not work for a cyclic dimension.

i use this for the dimension:

=pick(Dim, 'product_cycle', 'Total')

this for measure:

if('Dim' = 2,
// Totaal berekening: we negeren de dimensie-beperking
sum(TOTAL orders)
,

 Sum(orders))

any suggestions?

thanks in advance!

[marcus_sommer]

Maybe these hints are helpful:

Qlik Sense: Cyclic Dimension / Group - Qlik Community - 1880187

Solved: Qlik Sense Cyclic Dimension - getting the name of ... - Qlik Community - 2497990