Show previous year month data

pk — Tue, 06 Jul 2021 10:05:23 GMT

Hello Team,

Am showing data in below format- data up to 5 july2021

created 4 columns like
05-Jul-2021 - showing data of today - 1 day data
Up To 05-Jul-2021 - showing data of FTM or till date data(01july2021 to 05july2021)
Up To 05-Jun-2021 - showing data of previous month data(01june2021 to 05june2021)
Up To 05-Jul-2020 - showing data of previous years FTM dat(01july2020 to 05july2020)

following is the exp i used in 4th column-

num( sum({1<[Posting Date]={">=$(vMnstartPY)<=$(vMxDatePY)"},
GLCode={'004117801010',,'004310781010'},[Profit Center]-={'0000010626','0000010627'}>}Value/100000),'#,###.00' )

Variable-
vMnstartPY=date(Num(AddYears(MonthStart(Max(Posting Date])),-1)),'DD-MM-YYYY')
vMxDatePY=date(Num(AddYears(Max([Posting Date]),-1)),'DD-MM-YYYY')

if there is no sales for any customer in the current year and there is sale is in previous year (month) then that line item is not getting populate in the pivot chart

please help

topic Show previous year month data in QlikView

Show previous year month data