topic Re: Top 5 in QlikView

Top 5

Wed, 25 Nov 2020 16:16:04 GMT

Hi Experts,

please find the attached files

I have files like

jan1

jan2

jan3

jan4

jan5

if i go for reload i need top 3 files data.

Expected output:-

jan5

jan4

jan3

for ex:- when I add jan6,jan7,jan8,

here i need jan6 to jan8 files data.

Re: Top 5

tamilarasu — Thu, 28 Apr 2016 07:16:34 GMT

Kind of similar question. Check the below link.

Latest 3 Records

Re: Top 5

Thu, 28 Apr 2016 08:26:05 GMT

Hi Nagraj,

i am not getting correct output.

please give example with my files.

Re: Top 5

qlikview979 — Thu, 28 Apr 2016 09:24:32 GMT

Hi Nagraj,

i am not getting jan3,jan4,jan5 files data

please share the example with my files

Re: Top 5

tamilarasu — Thu, 28 Apr 2016 09:49:42 GMT

Hello Manoj,

Is this your real file name.? How will you store the file for 2017, 2018 and so on..? If you want a dynamic code, you need to add year in the file name. (i.e Jan2_2015). Let me know.

Re: Top 5

Thu, 28 Apr 2016 10:38:15 GMT

Hi,

Could you please see the below script and it will get to the Top 3 values. Please let me know if you find any issue.

sub DoDir (Root)

for each File in filelist (Root&'\*.txt')

input:

Load '$(File)' as Name,

FileSize('$(File)') as Size,

FileTime('$(File)') as FileTime

AutoGenerate 1;

next File

end sub

call DoDir('D:\QlikView\community\214825')

NoConcatenate

input:

load Name, Size, FileTime Resident input Order By FileTime Desc;

For vFileNo=1 to NoOfRows('input')

Let vFileName = Peek('Name',vFileNo-1,'input_file');

Load *,

'$(vFileName)' as FileName

From [$(vFileName)];

EXIT for WHEN vFileNo='3';

Thanks,
Sreeman

Re: Top 5

Thu, 28 Apr 2016 17:16:48 GMT

Hi QV,

Did you try my solution? Can you please try it and let me know is it fine?

Thanks,
Sreeman

Re: Top 5

qlikview979 — Fri, 29 Apr 2016 04:47:18 GMT

Hi,

i am not getting correct output. i will attach my files can you try with myfiles

Re: Top 5

tamilarasu — Fri, 29 Apr 2016 05:07:56 GMT

Mahesh,

I can give you the code which will work for your sample files. But my question is how will you save your future files (i.e 2017, 2018)...?

Re: Top 5

Fri, 29 Apr 2016 05:48:05 GMT

Hi Mahesh,

sure. please attach the files so that I will try it.

Thanks,
Sreeman

Re: Top 5

tamilarasu — Fri, 29 Apr 2016 06:32:59 GMT

Hi Mahesh,

Please do not create duplicate thread for the same question. Please check my response on your other thread.

Re: First 3 Sheets Data

Re: Top 5

Sat, 30 Apr 2016 10:18:42 GMT

Hi Nag,

Superb, i got the output

Thanks.

Re: Top 5

tamilarasu — Sun, 01 May 2016 03:30:18 GMT

Great. Please mark the helpful and correct answers to close this thread. So that it might help others in the future. Have a nice day.