Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to retrieve the last updated record froma table and displayit in textobject

Hi all,

AS per  the below attached excel file.. i am having a table with field names

[database name],

     [Last successfull reload date time],

     ErrorDate,

     ErrorTime,

     QVWname,

     ScriptError,

     ScriptErrorCount,

     ScriptErrorDetails,

     ScriptErrorNo

...So what i wanted is that.. i want to get the QVWName and the database name as per the last updated  error time...in this case the errortime is 14-4-2014 12:15:43..............and this is what i need to display on a text object.

So what i need in the output in the text object  is that:   ERROR OCCURRED IN DATABASE NAME:stflush AND QVWNAME:TitanExtract-InvJrnl.qvw... It will be very helpful if sumbody can help in solving this problem.

Thank You

1 Solution

Accepted Solutions
Gysbert_Wassenaar

='ERROR OCCURRED IN DATABASE NAME: ' & FirstSortedValue([database name], -ErrorTime) & ' AND QVWNAME ' & FirstSortedValue(QVWname, -ErrorTime)


talk is cheap, supply exceeds demand

View solution in original post

2 Replies
Gysbert_Wassenaar

='ERROR OCCURRED IN DATABASE NAME: ' & FirstSortedValue([database name], -ErrorTime) & ' AND QVWNAME ' & FirstSortedValue(QVWname, -ErrorTime)


talk is cheap, supply exceeds demand

View solution in original post

Not applicable
Author

Hi,

  thanks a lot ...your expression really helped....