topic Re: Store a QVD with a Variable Name in QlikView

Store a QVD with a Variable Name

stuwannop — Tue, 11 Jun 2013 14:33:55 GMT

Hi Everyone

I can't seem to quite figure this out. I load a list of opportuntities from Dynamics CRM and store them as a QVD on a regular basis. What I want to do now though is take a snapshot of these records every month and keep the QVD's, albeit with a different filename.

In my script I want to store the filename as the first day of every month (as I will schedule it to run in QMS on the 1st of every month) so the filenames will be created monthly with the format:

01/06/2013Pipeline.qvd

01/07/2013Pipeline.qvd

etc. etc.

I'm assuming I create a variable but how do I use that as part of the filename? I've tried: Store Pipeline as 'vdate'&Pipeline.qvd but it doesn't like it.

Also if anyone has any other views on how I can accomplish this "point in time" reporting I'd be very greatful. I plan to create multiple QVD's as the amounts of the pipeline records change month to month. i.e. Opportunity record one might have a value of £50,000 on the 1st June and £60,000 on 1st July and I need to track that.

Thanks

Stu

Re: Store a QVD with a Variable Name

Clever_Anjos — Tue, 11 Jun 2013 14:37:42 GMT

You are having problem because you´re using a "/" as a filename part, which is not allowed by Windows.

Use a "-" and will work as you write

Store Pipeline as '$(vdate)'&Pipeline.qvd(qvd)

Re: Store a QVD with a Variable Name

stuwannop — Tue, 11 Jun 2013 15:07:59 GMT

Thanks Anjos.

I've set my Variable as =date(today(),'dd-mm-yy')&'Pipeline' and it's coming out as '11-00-13Pipeline' - any idea why the month is registering a 0?

Thanks

Stu

Re: Store a QVD with a Variable Name

Clever_Anjos — Tue, 11 Jun 2013 15:23:24 GMT

Yes, you should use 'MM', because 'mm' stands for minute

Re: Store a QVD with a Variable Name

stuwannop — Tue, 11 Jun 2013 15:29:47 GMT

Ah yes of course - thanks again for your help.

Stu

Re: Store a QVD with a Variable Name

Clever_Anjos — Tue, 11 Jun 2013 15:57:53 GMT

You´re welcome. Keep in contact