Sort and Display the Latest date data

[#1]

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

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

[Chanty4u]

am nt sure ur tablename:

chnge that

TestTable1_Limits:

LOAD

  Max(Date) as MaxDate

Resident TestTable1_Limits;

[#3]

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;

[#4]

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

[#5]

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

[#6]

Hi Ramu,

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

Thank You,

Vinay

[#7]

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 )