Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
rpavan17
Creator
Creator

Find the Latest Value by date from a Table_Qliksense

Hi,

Can you help in getting the latest Index Value from a Table contains

Unique_ID,

Index,

TimeStamp

IDIndexTimeStamp
Orange322/05/2017 12:30:00
Orange4
22/04/2017 14:30:00
Apple315/02/2017 6:30:00
Apple416/03/2017 8:00:00
Mango321/05/2017 8:30:00
Mango421/05/2017 9:00:00

I have seen other discussions as well. But, i could not get the solution.

Expected Solution:

Orange = Index is 3

Apple = Index is 4

Mango= Index is 4

Thanks!!!

1 Solution

Accepted Solutions
nicolas_sinquin
Contributor III
Contributor III

Hye,

try

=FirstSortedValue(Index, -Timestamp)

View solution in original post

13 Replies
kaushiknsolanki

Hi,

What you need is firstsortedvalue() function.

Check below links.

http://www.learnqlikview.com/first-sorted-value-function-in-qlikview/

https://help.qlik.com/en-US/sense/September2017/Subsystems/Hub/Content/ChartFunctions/BasicAggregati...

Regards,

Kaushik Solanki

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".
nicolas_sinquin
Contributor III
Contributor III

Hye,

try

=FirstSortedValue(Index, -Timestamp)

rpavan17
Creator
Creator
Author

Hi,

If i give

=FirstSortedValue(ACTION_INDEX,Time_stamp)

It shows the first date index value.It has to show latest index.

=FirstSortedValue(ACTION_INDEX,-Time_stamp). It results '-'


Thanks

nicolas_sinquin
Contributor III
Contributor III

What i've done :

Table_Test:

LOAD * INLINE [

ID, Index, Timestamp

Orange , 3 , 22/05/2017 12:30:00

Orange , 4 , 22/04/2017 14:30:00

Apple , 3 , 15/02/2017 6:30:00

Apple , 4 , 16/03/2017 6:30:00

];

Dimension : ID

Measure : =FirstSortedValue(Index,-Timestamp)

and works fine ..

Are you sure you dont have null value in your date or index ?

rpavan17
Creator
Creator
Author

Hi..

Thank You for your answer. It looks like working when i give separate expression.

I am trying to add this in if  with other conditions.It gives error as Invalid Dimension.

Please help

nicolas_sinquin
Contributor III
Contributor III

can you post your code ?

rpavan17
Creator
Creator
Author

Hi,

It is

if( R_NAME = 'M_USER' AND FirstSortedValue(INDEX,-TIMESTAMP) ='3' ,'ForCancellation')

In Dimension formula, It is OK But when i click Apply, it is Invalid Dimension

nicolas_sinquin
Contributor III
Contributor III

I dont really understand your goal.

Can you provide sample data or sample application to work on?

rpavan17
Creator
Creator
Author

Hi,

I have give this in load script

Load

FirstSortedValue( INDEX,-Time_stamp) as R_C_Index

Resident DOCS;

It gives correct value if there are two values (3,4)for One ID. It gives 3.

But, If a ID contains value 4, then also it shows 3.

It looks like for any id, it shows 3 is the value of R_C_Index