Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

Show previous year month data

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' )

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

0 Replies