topic Re: FirstSortedValue() - "Error in Calculated Dimension" in QlikView

FirstSortedValue() - "Error in Calculated Dimension"

akidhossain — Sat, 16 Nov 2024 19:59:49 GMT

Hello!

I am trying to use the FirstSortedValue() function to return a Stage of a SKU based on rankings of the Stage. The following is what I have tried for my calculated dimension:

(1) FirstSortedValue([Stage],[Stage Ranking]) ------> Error in Calculated Dimension

(2) FirstSortedValue(AGGR([Stage],[SKU]),[Stage Ranking]) ------> Error in Calculated Dimension

Also to note: I have confirmed the the field [Stage Ranking] is in NUM format.

Any feedback on what I may be doing wrong? Thank you!

Re: FirstSortedValue() - "Error in Calculated Dimension"

StarinieriG — Fri, 27 Sep 2019 15:54:06 GMT

Hi,

try to see here it is explain

https://community.qlik.com/t5/New-to-QlikView/Error-in-calculated-dimension/td-p/1019381

Re: FirstSortedValue() - "Error in Calculated Dimension"

Brett_Bleess — Tue, 08 Oct 2019 14:57:06 GMT

Just a couple of other links for you that might be helpful:

https://community.qlik.com/t5/Qlik-Design-Blog/Pitfalls-of-the-Aggr-function/ba-p/1463275

https://community.qlik.com/t5/Qlik-Design-Blog/Don-t-get-aggr-avated-using-aggr/ba-p/1464136

Not sure they will really help, but worth a read.

Cheers,
Brett

Re: FirstSortedValue() - "Error in Calculated Dimension"

rwunderlich — Tue, 08 Oct 2019 15:27:12 GMT

It sounds like you want to do this calc over SKU, so I believe a calculated dim would be:

Aggr(FirstSortedValue([Stage],[Stage Ranking]), SKU)

-Rob