Aggr () , Rank() and GetCurrentField() in Qlik Sense

[S_G]

Hi All,

Below is the Calculated Dimension in QV  and it is working properly.

• Calculated Dimension = If(aggr(rank(sum(Sales)),$(=GetCurrentField(CycleG1)))<=$(Limit),CycleG1)

CycleG1 is one cyclic group having 3 dimensions i.e. Country, Region, State.

Limit is the input box , by default it is 5.

Now  I'm trying to convert the same in Qlik Sense but not getting the output as GetCurrentField() is not supported in Qlik Sense.

Any Leads to solve this.

TIA,

SAM.

[Vegar]

My best lead for solving this is to look into the GetObjectField() function as a replacement for GetCurrentField().

[S_G]

Thanks!!

But it is not working for this particular case..

the calculates dimension is = If(aggr(rank(sum(Sales)),$(=GetCurrentField(CycleG1)))<=$(Limit),CycleG1)

and there is also cyclic group.

[Vegar]

You might be right, but you could use it your mesure to exclude the dimensions that you don't want to see.

If(aggr(rank(sum(Sales)),$(=GetCurrentField(CycleG1)))<=$(Limit), YourMeasureExpression )

Attaching an example that could be of help.