Discussion Board for collaboration on QlikView Scripting.
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..
Go to Solution.
you can use if month is a datefield like May-16 and not only May
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))
But i am getting the values are 0.
please see this
Current Month v. Same Month Last Year
I have tried but still the value is 0..
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..
Use this to get previous year same month
for your requirement like this Date(MonthEnd(max(DATEFIELD),-12),'MMM-YY')