Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I want to compare the count of customers of Previous Month last date (Ex: 31-10-2019) and Current Month(Nov).
variables Using:
vmonth =Date([Month Start] -1,'DD-MM-YYYY')
vMaxdate =Date(Vmax,'DD-MM-YYYY')
vMindate =Date((Vmin),'DD-MM-YYYY')
Vmin = 43770
Vmax =43799
vMinDateMonthEnd =Date(MonthEnd(vMinDate),'DD-MM-YYYY')
vMaxDateMonthStart =Date(MonthStart(vMaxDate),'DD-MM-YYYY')
VminPrvDateMonthEnd =Date(MonthEnd(AddMonths(vMinDate,-1)),'DD-MM-YYYY')
Express Using:
Count({<[Status_Date] = {"$(vMinPrvDateMonthEnd)"}>} Customer)--- Opening Count
But its showing Current Month Count( Ex : NOV).
How I can get the Previous month. please help me with this Express to get the previous month count.
Thanks & Regards,
Chandra Sekhar
Hi All,
Any suggestion. Please help us with this.
Thanks,
Chandra
Chandra, have a look at the following Design Blog post, I believe it may give you a point in the right direction.
https://community.qlik.com/t5/Qlik-Design-Blog/Year-over-Year-Comparisons/ba-p/1462927
Regards,
Brett