topic Re: Aggr () , Rank() and GetCurrentField() in Qlik Sense in App Development

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

S_G — Tue, 10 Nov 2020 12:40:17 GMT

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 — Tue, 10 Nov 2020 13:01:15 GMT

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

S_G — Tue, 10 Nov 2020 13:26:41 GMT

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 — Tue, 10 Nov 2020 13:55:06 GMT

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.