topic Re: Loading QVDs in QlikView

Loading QVDs

Mon, 25 May 2015 14:03:20 GMT

Hi Experts

I got Sales QVDs in a folder from 2014

Sales_2014_01

Sales_2014_02

Sales_2014_03

Sales_2014_04

Sales_2014_05

Sales_2014_06

Sales_2014_07

Sales_2014_08

Sales_2014_09

Sales_2014_10

Sales_2014_11

Sales_2014_12

Now I want to chose the data only from 2014_05

I dont want to load the QVDs one by one

Is there a dynamic Way of Loading it from 2014_05

Please Suggest

Re: Loading QVDs

Clever_Anjos — Mon, 25 May 2015 14:20:15 GMT

What about

LOAD *

FROM Sales_2014_05.qvd(qvd)?

Re: Loading QVDs

rwunderlich — Mon, 25 May 2015 14:25:30 GMT

I'm assuming you want to calculate which QVD to load based on the current date?

LET vQvd = 'Sales_' & date(today(1),'YYYY_MM') & '.qvd');

LOAD * FROM $(vQvd) (qvd);

-Rob

http://masterssummit.com

http://robwunderlich.com

Re: Loading QVDs

Anonymous — Mon, 25 May 2015 15:18:32 GMT

Hi John

You can load all files QVD and add field 'NameQVD', separate in Set Analyses.

Ex.

LOAD *

, filename() AS File

FROM Sales_2014_*.qvd(qvd);

Best Regards,

Tiago Ferrucio

Re: Loading QVDs

Mon, 25 May 2015 16:14:08 GMT

I want only the QVDs from May

ie., from 2014_05

Re: Loading QVDs

Clever_Anjos — Mon, 25 May 2015 16:35:07 GMT

2014_05 is a folder or a single QVD?

Re: Loading QVDs

rwunderlich — Mon, 25 May 2015 17:05:15 GMT

You want the QVDs from 2014_05 forward.

FOR EACH file in 'C:\mydir\*.qvd'

IF '$(file)' >= C:\mydir\2014_05.qvd' THEN

LOAD * FROM [$(file)} (qvd);

ENDIF

NEXT file

You may have to actually extract the YYYY_MM portion to do a valid comparison, but hopefully the loop gets you started.

-Rob

Re: Loading QVDs

Mon, 25 May 2015 17:37:23 GMT

HI Rob

Thank You

Let me check with this Method

Re: Loading QVDs

Mon, 25 May 2015 17:38:14 GMT

HI Anjos

Its a single QVD

Re: Loading QVDs

pratap6699 — Mon, 25 May 2015 17:45:23 GMT

LOAD * From sales.QVD where fieldname=2014_05;

Re: Loading QVDs

MarcoWedel — Mon, 25 May 2015 18:18:00 GMT

LOAD * FROM Sales_*.qvd (qvd)

Where Right(FileBaseName(),7)>='2014_05';

Re: Loading QVDs

Tue, 26 May 2015 08:16:32 GMT

Hi Marco

It was not Working

Please Suggest some Solution

I want to Load QVDs >='2014_05'

Re: Loading QVDs

rwunderlich — Tue, 26 May 2015 16:11:39 GMT

Can you post the script you are using?

-Rob