Discussion Board for collaboration related to QlikView App Development.
i am using a Expression in a TEXT object in 2 different way and getting 2 different out but
my Max MonthYear is : Feb-2015.
1. ) =date(addmonths(max(MONTHYEAR),-3), 'MMM-yyyy') OUTPUT : Nov-2014 ( Correct )
2. ) =date( $(=AddMonths(max(MONTHYEAR),-3)),'MMM-yyyy') OUTPUT : Dec-1899 ( Wrong)
if i am removing Date() function then its show numeric value as below :
3) =$(=AddMonths(max(MONTHYEAR),-3)) OUTPUT : 0.0054617676266137
Kindly let me know what is the issue.
Actually i want to get last 3 Month sum of Turnover so i need to use this into the set analysis.
Thanks & Regards,
Would be good to post an example and to see your data-formats.
It may also help to copy your formulas into a straight table and leave the expression label empty. On mouse-over you then can see the individual values used for the calculation.
yes i know if i use into a variable i get the information but why for such small expression i use variable.
even lots of example in qlikview community show that you can direct use such expression in set analysis.
The $(= ) applied to the date is calculating the values in the date as numbers divided by the various date parts.
So $(= 27/3/15) gives 27/3 = 9 then 9/15 = 0.6 !
$(= 27/3/2015) gives 27/3 = 9 then 9/2015 = 0.00446650124 !
But why the below expression showing two different result.
In the Label is showing the right information, but in Expression it showing the wrong.
with your above code you will get last 2 months and plus current MTD
to get last 3 months you will have to select data where Date <=Date(=monthstart(today())-1))
AND Date >=Date(=MonthStart(MonthStart(Today())-85)
And if you can upload sample qvw that would be great to help !