Qlik Community

Ask a Question

App Development

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

Announcements
April 22, 2PM EST: Learn about GeoOperations in Qlik Sense SaaS READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
S_G
Contributor
Contributor

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

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.

3 Replies
Vegar
Partner
Partner

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

Plees ekskuse my Swenglish and or Norweglish spelling misstakes
S_G
Contributor
Contributor
Author

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
Partner
Partner

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 )

 

Vegar_1-1605016500117.png

 

 

Attaching an example that could be of help.

 

Plees ekskuse my Swenglish and or Norweglish spelling misstakes