hi, please help me out to find the fields FTD,MTD,YTD. the date field is FKDAT(taking from sap) and i have linked this with normal Calendar Date as follows CalendarMaster: LOAD &n...
...his formula for YTD average :
RangeAvg(above(Avg ({<PERIOD = {">=1/1/2019<=01/01/2025"}>} PROD),0,12) )
it works until 01/12/2019 but after that I have a rolling average over 12 m...
Hi Guys, Could someone help me out a bit. I've already used the advice from topic: Year to Date vs Year to date Last Year But for some reason my calculation doesnt works for the prioryear. I a...
Hi everyone, I have read topics about this as it has been asked numerous times but I am not able to make it work for some reason on my own app. I have invoice table with invoice date and I ha...
Hi
I am learning Qlik Sense and I want to make a date comparison of YTD, MTD, FYTD
can someone please guide me on how to write a set expression step by step and write a code for YTD, F...
=Sum({<OrderDate={">=$(=yearstart(addyears(max(OrderDate)),-1)<=$(=addyears(max(OrderDate)),-1))}>"}Sales) this expression showing error[error in set modifier expression] how to resolve...
...elected: Keep the current YTD behavior When specific months are selected (e.g., Aug & Sept): Show the sum for just those selected months (Aug + Sept), not the cumulative total from January Basically, I...
Hi all,
I have prepared a script that will calculate the MTD, YTD, QTD, WTD without using complex set analysis using the As-Of table concept.
One more App is attached : Which c...
Hi, Having a bit of trouble creating a YTD/MTD measure in qlik sense. I have read the below and it's not making a lot of sense to me unfortunately. YTQ, QTD, MTD and WTD My Date Field i...
Hello everyone, I read all discussions on this topic, but I couldn't find solution. I'm trying to get number of customer for YTD and Previous YTD, but it seams like condition doesn't work, e...
