Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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)
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)
Hi Varun
Your solution can fix this problem, thx a lot!
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)