topic Re: Need last Year in QlikView

Need last Year

bharatkishore — Mon, 05 Sep 2016 10:01:24 GMT

Hello All,

I have a month field where the data is like May-16,Jun-16.

Now my requirement is i need to get last year. For example when i select May-16 i should get May-15.

I have given max(month)-12 but it is converting to integer..like 42479..Can you please help me on this..

Thanks,

Bharat

Re: Need last Year

antoniotiman — Mon, 05 Sep 2016 10:08:17 GMT

Hi,

Try

MonthName(AddMonths(Max(Month),-12))

Regards,

Antonio

Re: Need last Year

Anonymous — Mon, 05 Sep 2016 10:17:55 GMT

you can use if month is a datefield like May-16 and not only May

addyears(max(month),-1)

Re: Need last Year

bharatkishore — Mon, 05 Sep 2016 10:18:45 GMT

Thanks Antonio for the reply..

I have given the following condition and in vlastyear i have given the following condition =MonthName(AddMonths(Max(S5_Month2),-12))

=sum(if(S5_Month2=vLastYear,S5_Leads))..

But i am getting the values are 0.

Re: Need last Year

agomes1971 — Mon, 05 Sep 2016 10:23:31 GMT

Hi,

please see this

Current Month v. Same Month Last Year

HTH

André Gomes

Re: Need last Year

antoniotiman — Mon, 05 Sep 2016 10:26:54 GMT

Try

Sum({<S5_Month2={'$(=vLastYear)'}>} S5_Leads)

Re: Need last Year

bharatkishore — Mon, 05 Sep 2016 10:33:41 GMT

I have tried but still the value is 0..

Re: Need last Year

antoniotiman — Mon, 05 Sep 2016 10:41:58 GMT

Instead of

MonthName(AddMonths(Max(Month),-12))

try

Date(AddMonths(Max(Month),-12),'MMM-YY')

Re: Need last Year

bharatkishore — Mon, 05 Sep 2016 10:44:51 GMT

Please find the attached qvw...

When it is without selection it is coming but when i select any month the data is becoming 0..Kindly check..

Re: Need last Year

Mon, 05 Sep 2016 11:09:57 GMT

Use this to get previous year same month

MonthEnd(max(DATEFIELD),-12)

for your requirement like this Date(MonthEnd(max(DATEFIELD),-12),'MMM-YY')

Re: Need last Year

antoniotiman — Mon, 05 Sep 2016 11:35:08 GMT

See attachment

Re: Need last Year

bharatkishore — Mon, 05 Sep 2016 11:42:23 GMT

Thanks a lot Antonio..I don't know where i missed it..Can you please tell me..

Re: Need last Year

Mon, 05 Sep 2016 11:50:27 GMT

try like this last year may-15 data

=sum({<DATEFIELD={">$(=Date(addMonths(min(DATEFIELD),-12))<=$(=Date(addmonths(max(DATEFIELD),-12)))"}>}measure)