topic Re: Sort and Display the Latest date data in QlikView

Sort and Display the Latest date data

Fri, 26 Feb 2016 09:25:53 GMT

Hello Team,

I have come across one major challenge and i would request for your help and suggestions. I did the research in the QlikView community page and i didn't find any required solutions for my issue.

Issue:

I have created one QlikView dashboard and I am trying to sort and display the LATEST DATE data on the NEW Sheet when the QlikView dashboard is open so, i used the below formula but its not working as expected can some one have a look and help me at the possible earliest.please

This is little urgent kindly,let me know your thoughts at the possible earliest.

<---------------------------------------------------------->

TestTable1_Limits:

LOAD

Max(Date) as MaxDate

Resident TestTable1;

Let vMaxDate = Num(Peek('MaxDate', 0, 'TestTable1_Limits'));

TestTable2:

Load

'|' as Dummy

Resident TestTable1

Where Date = Date('$(vMaxDate)')

;

DROP Table TestTable1;

<--------------------------------------------------------------->

The Script error that i received

===================================

Table not found

TestTable1_Limits:

Load

Max(Date) as max date

Resident TestTable1

====================================

Re: Sort and Display the Latest date data

Chanty4u — Fri, 26 Feb 2016 10:37:30 GMT

am nt sure ur tablename:

chnge that

TestTable1_Limits:

LOAD

Max(Date) as MaxDate

Resident TestTable1_Limits;

Re: Sort and Display the Latest date data

Fri, 26 Feb 2016 10:52:28 GMT

Hi Vinay,

There is no error ,

Its Working fine for me

TestTable1:

LOAD

CREATION_DATE

FROM

exporttransHistory.qvd

(qvd);

TestTable1_Limits:

LOAD

Max(CREATION_DATE) as MaxDate

Resident TestTable1;

Let vMaxDate = Num(Peek('MaxDate', 0, 'TestTable1_Limits'));

TestTable2:

Load

'|' as Dummy

Resident TestTable1

Where CREATION_DATE = Date('$(vMaxDate)')

;

DROP Table TestTable1;

Re: Sort and Display the Latest date data

Fri, 26 Feb 2016 11:07:07 GMT

Hi Chanty,

Thanks for your response. Unfortunately it did not work.

I think there is some issues with the (TestTabel2) code paragraph.

If not my script. I want to display the Latest Date Data can somebody help me?

Thank You,

Vinay

Re: Sort and Display the Latest date data

Sun, 28 Feb 2016 14:17:59 GMT

Hi Ramu,

Many thanks for your help and looking into my concern.

However, the issues still remains the same. I used your formula but i found 3 errors can you please have a look on the attached error screen shot doc and advise.

Error No 1- exporttransHistory.qvd. The system cannot find the file specified.

Error No 2- File Not found - <CREATION_DATE>

TestTabel1_Limits:

LOAD

Max(CREATION_DATA) as MaxDate

Resident TestTabel1

Error No 3- Field not found - <CREATION_DATE>

TestTable2:

Load

'|' as Dummy

Resident TestTable1

Where CREATION_DATE = Date('')

Thank You,

Vinay

Re: Sort and Display the Latest date data

Mon, 29 Feb 2016 14:02:20 GMT

Hi Ramu,

By any chance do you know what could be the issue? Please

Thank You,

Vinay

Re: Sort and Display the Latest date data

Tue, 01 Mar 2016 06:30:18 GMT

Dear Vinay,

Have a nice day.

Error No 1- exporttransHistory.qvd. The system cannot find the file specified.

That QVD file is my data file .Try to replace any other data file in the place of exporttransHistory.qvd .

one you change the data file the remaining errors also resolved.

any helf put a request my skype number 8802177467.

feel free to contact (i mother language Telugu )