topic Re: Match Dates in QlikView

Match Dates

Thu, 08 May 2014 07:01:06 GMT

Hi All,

Please see attached spreadsheet. What are the different functions that I can I use so that Qlikview will look at today's date and tell me what the corresponding trading day is.

I need to use this result in a sales ytd computation for prior years, but ytd is not defined by conventional calendar dates, but trading days which are arbitrary.

Thank you

Re: Match Dates

rajat2392 — Thu, 08 May 2014 07:06:43 GMT

Hi Herbert

while loading data in Main Tab, Date Format is given as M/D/YYYY..so you can format your date as same....

Regards

Re: Match Dates

SergeyMak — Fri, 09 May 2014 01:52:51 GMT

Hi,

You need to build a calendar table, use function Today() and some set analysis to define the range of YTD, Previous YTD, etc.

Some examples attached.

You can find more about how to calculate YTD, ITD etc if you use search "YTD" in the community