...UM({<YYYYMM={"$(='>=' & date(AddMonths(max(FULL_DATE),-3),'YYYYMM'))"},MM=,YYYY=>}AMOUNT) but it retrieves 0 , (not the actual result) any ideas? advanced thanks
Hi all i have an expression with AddMonths in SetAnalysis (below) working fine with Today() as date but when trying to connect to model Date Field both expressions retrieve same value any i...
Hi, i´m experiencing some problems related to the use of this function with setanalysis. My requeriment is to calculate the sum of sales in a three month period of time based in the Start D...
...esolved only for the previous month at any given point in time..can somebody please tell me whats going wrong with my setanalysis? When i add the addmonths expression my expression stops working c...
Hi guys, I am stuck on something and since I'm new to setanalysis I dont know how to procced. I have the following expression: Sum({<Month = {"$(=month(addmonths(Max(Date),-1)))"},Y...
...et vMaxDay = '=day(max(Date))'; let vMaxMonth = '=month(max(Date))'; let vMaxYear = '=max(Year)'; let vPriorMonth = '=month(addmonths(max(Date),-1))'; let vPriorMonthYear = '=Year(addmonths(max(D...
Hi, Is it possible to use Addmonths in setanalysis? I want to rewrite this: sum ({$ <BETBOKFD_IN = {">2008-06-30"}> }_ForsCounter) With something like this: sum ({$ &l...
Hello, Guys need your help! I want to create an expression with average of next three months. I tried to use this one with addmonths function, but it's not working Avg({<M...
This QlikView shows how basic SetAnalysis syntax can be used to deliver a Prior Period Comparison. Rather than taking the approach of flagging rows as being in certain periods at load t...