Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Partner
Partner

FirstSortedValue on Calculated Position

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

1 Solution

Accepted Solutions
Highlighted
Partner
Partner

Re: FirstSortedValue on Calculated Position

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.

View solution in original post

4 Replies
Highlighted
Not applicable

Re: FirstSortedValue on Calculated Position

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

Attached.

Highlighted
Partner
Partner

Re: FirstSortedValue on Calculated Position

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

Highlighted

Re: FirstSortedValue on Calculated Position

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

Highlighted
Partner
Partner

Re: FirstSortedValue on Calculated Position

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.

View solution in original post