topic Re: Loading QVDs in QlikView

Loading QVDs

Mon, 06 Jul 2015 13:30:28 GMT

Hi Experts

I have Sales QVDs for 2015 Month Wise

and my current month sales QVDs got updated Daily

Sales_2015_01

Sales_2015_02

Sales_2015_03

Sales_2015_04

Sales_2015_05

Sales_2015_06

Sales_2015_07

Now I loaded my QVDs into my QVW

My QVW get reloaded in the Daily basis in QMC

Every Time its reloading from the beginning of the year

I don't want to do an incremental load,

Is there a way of making my Current Month sales data only got reloaded in My QVW

Please Suggest

Re: Loading QVDs

sunny_talwar — Mon, 06 Jul 2015 13:37:55 GMT

What if do this:

LET vFile = 'Sales_' & Year(Today()) & '_' & Month(Today());

and then use it like this may be

FROM $(vFile).qvd (qvd);

Re: Loading QVDs

Gysbert_Wassenaar — Mon, 06 Jul 2015 13:41:24 GMT

If you have Qlikview Publisher you can try using a Partial Reload. You'll probably won't add anything but complexity though. You can find an example here: https://community.qlik.com/docs/DOC-5427

Re: Loading QVDs

Mon, 06 Jul 2015 14:01:27 GMT

HI Sunny

I made slight change in the script for defining the variable Month in Num

LET vFile = 'SALES_' & Year(Today()) & '_' & NUM(Month(Today()));

I actual file path is SALES_2015_07

how can i achieve this

Re: Loading QVDs

sunny_talwar — Mon, 06 Jul 2015 14:06:59 GMT

Try this:

LET vFile = 'SALES_' & Year(Today()) & '_' & Num(Month(Today()), '00');

Re: Loading QVDs

Mon, 06 Jul 2015 14:13:29 GMT

HI sunindia & Gysbert Wassenaar

Thanks For your Help!

Re: Loading QVDs

sunny_talwar — Mon, 06 Jul 2015 14:16:13 GMT

No problem Bud

Glad we were helpful.

Best,

Sunny