topic Re: Firstsortedvalue from multi columns in QlikView

Firstsortedvalue from multi columns

Wed, 25 Nov 2020 16:16:04 GMT

Hi Guys

Here is my purpose:

I want to get the latest data from imported data sheet, for example:

Based on F2='予算', TestedDate='2016-11',Type='売上高実績' these three conditions, and combined with Key(auto number function), I can locate the latest data.

So I write Sum({<Type={'売上高　実　績'},Key={"$(=FirstSortedValue({<Type={'売上高　実　績'},TestedDate={'2016-11'},F2={'予算'}>} Key, -Key))"}>} Data) in expression.

However, after I applied the expression, the charter display nothing.

I don't know what's wrong with the expression, the Firstsortedvalue statement seems working well.

Someone please help me out, thank you.

Re: Firstsortedvalue from multi columns

techvarun — Wed, 16 Aug 2017 04:05:23 GMT

Hi,

As far as i know FirstSortedValue can hold only 2 parameters.

May be create something like below to get the result.

LOAD *, Type&F2 as FSVKey Resident Table5;

Expression : Sum({<Type={'売上高　実　績'},Key={"$(=FirstSortedValue({<FSVKey={'売上高　実　績预算'},TestedDate={'2016-11'}>} Key, -Key))"}>} Data)

Re: Firstsortedvalue from multi columns

Wed, 16 Aug 2017 05:06:22 GMT

Hi Varun

Your solution can fix this problem, thx a lot!

Re: Firstsortedvalue from multi columns

qliksus — Wed, 16 Aug 2017 05:42:48 GMT

You don't have data for the set analysis filter used . I mean for the date 2016-11 the corresponding value in

F2 = '予算 ' is not available when you use the below expression it shows data

FirstSortedValue({<Type={'売上高　実　績'},TestedDate={'2016-11'},F2={'实际'}>} Key, -Key)