
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
FirstSortedValue() - "Error in Calculated Dimension"
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!

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
try to see here it is explain
https://community.qlik.com/t5/New-to-QlikView/Error-in-calculated-dimension/td-p/1019381
.png)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
