...uying_Store_Counter]) I also tried setting a variable vDateLY to =date(addmonths(MonthYear,-12),'MMM-YYYY') And then set the expression to =count(total distinct {$< MonthYear={'$(=vDateLY)'} >} %[B...
...and taken some Inputs. In a straight table, I wrote the setanalysis as follows, count({$<[Bill.DDMM] = {">=(Date(addmonths(max([DOB]), -1), 'DD-MM'))<=(Date(addmonths(max([DOB]), 1...
hye all, I'm in trouble using addmonth in a setanalysis. In Load : Load Date(Date#(DAT_CONSO_COJ,'YYYYMMDD'),'DD/MM/YYYY') as DAT_CONSO_CONS_NEW, DAT_CONSO_COJ, &n...
Hello all. I'm want to show sales in the same period (of selection) of 12 months back . I hold 2 variables: vDateMin = MonthStart(AddMonths(min(Date), -12)) vDateMax = MonthEnd(AddMonths(M...
Dear all, I have this setanalysis: =sum({<Date= {"=monthend(addmonths(max(Date),-1))"} >} Sales) For some reason it is always giving me the total Sales and not the month prior to the l...
...o this setanalysis to calculate amount between current months and 7 next months :
=Sum({<[Date_rec] = {'>=$(=vCurrentMonth)<=$(=v7NextMont)'}>}[Amount])
But it's doesn't work.&n...
...bsp;
=Date(MonthStart(AddMonths(Max([Calendar Date]),-35)),'MM/DD/YYYY')
vRollingEnd is:
=Date(MonthEnd(Max([Calendar Date])),'MM/DD/YYYY')
It would be nice to have this go to the n...
I came across qlik documentation and spot addMonths function. In my case, I have SQL line that I want to translate to qlik logic, and I don't see addDate function in qlik sense. I am wondering if q...
...ppreciated
Count(distinct {<[Enrollee Date of Birth.autoCalendar.Date]={">=$(=Date(AddMonths(Today(),-216)))<=$(=Date(AddMonths(Today(),-252)))"}>} medicaidID)