topic As Of Help??? in QlikView

As Of Help???

gauthamchilled — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I attached qvw file. I need a help on Asoftable.

When i select Asofyear - 2016, asofmonth - march and period type as YTD.

data for march value is

but when i just toggle the month from mar to april...the march value changes..

can any one help?

Thanks.

Gautham

Re: As Of Help???

gauthamchilled — Mon, 19 Dec 2016 08:13:03 GMT

I think the data for march 31st is converted to april automatically...can any one help ?

Re: As Of Help???

asgardd2 — Mon, 19 Dec 2016 08:22:08 GMT

I think you don't have a full data model (all variants of links)

For example Total Premium = 1615706,8390509 don't linked to Apr 2016 .

If i understood coorrectly you need data model, like this (for ex. 1 year):

IncomeDate - MonthYear

Jan 2016 - Jan 2016

Feb 2016 - Feb 2016

March 2016 - Jan 2016

March 2016 - Feb.2016

March 2016 - March 2016

...

Re: As Of Help???

Gysbert_Wassenaar — Mon, 19 Dec 2016 08:32:04 GMT

Your AsOf calendar is not linked to all the dates. If you select Apr then jan 31 and march 31 are missing.

I also don't understand why you use every single income date as MonthYear instead of creating as MonthYear field from only the start date of the month. See this example: AsOf Table Examples.qvw