Discussion Board for collaboration on QlikView Layout & Visualizations.
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 DimensionAlso 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!
try to see here it is explain
Just a couple of other links for you that might be helpful:
Not sure they will really help, but worth a read.
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)