Loading QVDs

[#1]

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

[sunny_talwar · Accepted solution]

What if do this:

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

and then use it like this may be

FROM $(vFile).qvd (qvd);

[Gysbert_Wassenaar]

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

[#4]

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

[sunny_talwar]

Try this:

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

[#6]

HI sunindia & Gysbert Wassenaar

Thanks For your Help!

[sunny_talwar]

No problem Bud

Glad we were helpful.

Best,

Sunny