topic Re: Date Issue in QlikView

Date Issue

Fri, 19 Sep 2014 11:06:10 GMT

Hi,

I have a field YearValue which has values such as 1-2014, 2-2014 etc. I wish to calculate last 12 months from 2 -2014 which would be 2 -2013. and store it in a variable. How do i do the same?

Thanks,

Asma

Re: Date Issue

tresB — Fri, 19 Sep 2014 11:10:56 GMT

One value value - last 12th month, right? If so then then try like:

=Date(AddMonths(MakeDate(SubField(YearValue, '-',2), SubField(YearValue,'-',1)) , -12), 'MM-YYYY')

Update: Corrected

Re: Date Issue

Fri, 19 Sep 2014 13:30:51 GMT

How do i find out the last 12th month? In this case, when we are selecting a value from the YearValue filed, then we are able to see the last 12th month.

e.g. currently we are in Sep 2014, so last 12th month should be displayed as Sep 2013 in a text box.

Re: Date Issue

anbu1984 — Fri, 19 Sep 2014 14:27:18 GMT

=SubField('Sep 2014',' ',1) & ' ' & (SubField('Sep 2014',' ',2)-1)

Re: Re: Date Issue

ecolomer — Fri, 19 Sep 2014 14:29:22 GMT

see this example