topic Re: This month vs. previous month in QlikView

This month vs. previous month

Wed, 08 Aug 2012 14:56:46 GMT

Hi,

I am trying to compare a QVD from this month with previous month. Each month I create a QVD with the month in the title. Please see below:

Let vtoday = Date(today(1),('MMM YYYY'));

Store PIF_History into Y:\PL Operations\Leaders\Analyst\SSharma\PIF_History\PIF_History_$(vtoday).qvd(qvd);

I need to set up another variable which will bring in previous month. For example, in July I need to compare results with June.

Please let me know if you can help or if you need further explanation.

Thank you.

Re: This month vs. previous month

IAMDV — Thu, 09 Aug 2012 12:22:25 GMT

Saurav - How are you doing mate?

As long as the schema of both the QVDs are same...you can use the Exists() function to compare the fields within QVD. You can use the Exists() with the Load statement and check both the QVDs. Please post the sample application if you need the syntax/script.

I hope this helps!

Cheers,

www.QlikShare.com

Re: This month vs. previous month

Thu, 09 Aug 2012 12:39:48 GMT

Use a wildcard load

LOAD *

FROM PIF_History_*.qvd;

That will load all files, you will have to tweak if if you do not want them auto concatenating