Recent qvd

[qlikview979]

Hi Experts,

please find the my  attached  source files.

I have  source1 folder Three Qvds  names like

2016_01_01.qvd

2016_01_02.qvd

2016_01_03.qvd

qvd creation time is 11:10:10 AM

and

source2 folder Three Qvds names like

2016_01_01.qvd

2016_01_04.qvd

2016_01_05.qvd

Qvd creation time is 11:15:15 AM

then i have loaded all qvd's into qlikview .Check here  2016_01_01.qvd name having 2 qvd's  ..

coming to my requirement

i need latest with same  name 2016_01_01.qvd  from source2

Output:  i want 2016_01_01.qvd   from source2 because this is the latest qvd based on timestamp.

[Kushal_Chawda]

just do right click on QVD and see the last modified date. It should be the same as filetime1 and filetime2.

To check the code is working fine, manually overwrite the QVD in source2 and try to run the code

[qlikview979]

Hi,

I done like that  but i am getting source1 data only.

Regards,

Mahesh

[qlikview979]

now  i got the same date with time in filetime1 and filetime2.

Regards,

Mahesh

[qlikview979]

Hi Tim Driller,

in your script filename showing is showing black.

Regards,

Mahesh

[qlikview979]

Hi Tim Driller,

in your script filename showing is showing black.

Regards,

Mahesh

[Kushal_Chawda]

see the attached. Working fine for me. attached sample QVDs and QVW file.

[qlikview979]

Hi Kushal,

Attached file is missing,please attach the file.

Regards,

Mahesh

[qlikview979]

Hi Kushal,

I got your Attached files.   you also got the qvd's from Source1. QVD's names like 201526,201527,201528 in front end.

here i need 201527.qvd  from your Source2 folder.compare  source1 201527.qvd to source2 201527.qvd . source2 201527.qvd is latest we can identify the  qvd reload time.

Note:  I need 201527.qvd only from your Source2.

[qlikview979]

Hi Kushal,

I got your Attached files.   you also got the qvd's from Source1. QVD's names like 201526,201527,201528 in front end.

here i need 201527.qvd  from your Source2 folder.compare  source1 201527.qvd to source2 201527.qvd . source2 201527.qvd is latest we can identify the  qvd reload time.

Note:  I need 201527.qvd only from your Source2.

[qlikview979]

Hi,

Please find my Attached Qvd's.