topic Re: Calculated Dimension in QlikView

Calculated Dimension

tmumaw — Sat, 16 Nov 2024 02:53:19 GMT

I have this calculated dimension and I am interested in only ranked values between 2 and 10. I'm using this to get my top 10. Is there a way of only getting 2 - 10?

=if(aggr(Rank(Count(DISTINCT([Requisition]))),[SF_Job]) < 11,[SF_Job])

Re: Calculated Dimension

sunny_talwar — Mon, 29 Jul 2019 12:33:01 GMT

May be this

=Aggr(If(Rank(Count(DISTINCT [Requisition])) > 1 and Rank(Count(DISTINCT [Requisition])) < 11, [SF_Job]), [SF_Job])

Re: Calculated Dimension

tmumaw — Mon, 29 Jul 2019 12:39:59 GMT

Thanks Sunny that worked. Do you know of a way to start the ranking at 2 vs. 1?

Re: Calculated Dimension

sunny_talwar — Mon, 29 Jul 2019 12:41:50 GMT

May be just add 1 to the Rank?

RangeSum(Rank(...), 1) or Rank(...) + 1