topic Re: FirstSortedValue on Calculated Position in QlikView

FirstSortedValue on Calculated Position

PhilippZiemer — Thu, 21 Aug 2014 14:09:40 GMT

Hey Community,

I got a rather strange Problem. I have two sliders to select values in a list under the dimension of a chart by using the function FirstSortedValue. The first slider selects an absolut position in a variable and works perfectly. The second slider selects a relative position, e.g. I want the item at 25% of the list. I use the relative Position times the count of items under the dimension. This always produces an "Allocated memory exceeded" error. You can reproduce the error by activating the last expression in the chart.

I would be really thankful for a solution or a workaround.

Best

Philipp

Re: FirstSortedValue on Calculated Position

Thu, 21 Aug 2014 14:21:13 GMT

How about this expression: Date(Min(DATE,[Value Pos Relative]))

Attached.

Re: FirstSortedValue on Calculated Position

PhilippZiemer — Fri, 22 Aug 2014 08:16:05 GMT

For some reason this is as well not working. Try the right slider. It will always result in the first value.

Re: FirstSortedValue on Calculated Position

CELAMBARASAN — Fri, 22 Aug 2014 08:31:38 GMT

Chart object might gets corrupted. Did you tried recreating(not copying the existing) it again?

Re: FirstSortedValue on Calculated Position

PhilippZiemer — Fri, 22 Aug 2014 10:26:01 GMT

I came to the conclusion that it is not possible to calculate the rank n for the function Min or the position n for FirstSortedValue under the dimension of the chart.