topic MTD for Previous Year in QlikView

MTD for Previous Year

qlikviewaf — Wed, 25 Nov 2020 16:16:04 GMT

Hi Guys,

i have been read all forum but i got no solution for my previous month to date.

i'm using this formula on the column (MTD 2016) but is not working

Sum({<Area-={'Area-not-available'},Year=, Quarter=, Week=,Day=,Invoice_Date_Num=, Invoice_Date_Num={">=$(=Num(MonthStart(addyears(Max(Invoice_Date_Num),-1))))<=$(=addyears(Max(Invoice_Date_Num),-1))"}>}

ExtendedUSD)

In the example attached the column MTD 2016 should be, selecting 13 june 2017 , 584 $ but i got 2419 $.

How this can be adjusted? What i'm doing wrong?

Thank you

Re: MTD for Previous Year

aarkay29 — Wed, 21 Jun 2017 14:12:23 GMT

=if(vExcludeInstrumentSales,

ExtendedUSD),

Sum({<Area-={'Area-not-available'},Year=, Quarter=, Week=,Day=,Invoice_Date_Num=, Item_Category={$(vNoInstruments)}, Invoice_Date_Num={">=$(=Num(MonthStart(addyears(Max(Invoice_Date_Num),-1))))<=$(=Num(addyears(Max(Invoice_Date_Num),-1)))"}>}

ExtendedUSD))/1000

You forgot to change the date format to Num in the <= exp

Re: MTD for Previous Year

qlikviewaf — Wed, 21 Jun 2017 14:20:16 GMT

monster! finally works