Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

rpavan17
New Contributor II

Firstsortedvalue() not working in Load Script on QlikSense

Hi,

Does Firstsortedvalue() function works in Load Script. It gives me Invalid Dimension if i load.

Thanks

Tags (1)
1 Solution

Accepted Solutions
MVP
MVP

Re: Firstsortedvalue() not working in Load Script on QlikSense

You have multiple fields without aggregation which you have not added to the GROUP BY statement... you have three options

Capture.PNG

1) Add these to the Group By statement

2) Remove them from the load statement

3) add aggregation around them

3 Replies
MVP
MVP

Re: Firstsortedvalue() not working in Load Script on QlikSense

It should, what is the exact script you are trying? Also, did you have Group By clause?

rpavan17
New Contributor II

Re: Firstsortedvalue() not working in Load Script on QlikSense

Load

DOC_ID,

FirstSortedValue( ACTION_INDEX,-R_C_Time_stamp) as R_C_Index,

ACTION_INDEX,

SENDED_TO_TIMESTAMP

Resident Add_Cancellation_Return_Status

Group By DOC_ID;

Capture.PNG

MVP
MVP

Re: Firstsortedvalue() not working in Load Script on QlikSense

You have multiple fields without aggregation which you have not added to the GROUP BY statement... you have three options

Capture.PNG

1) Add these to the Group By statement

2) Remove them from the load statement

3) add aggregation around them