topic comparing Opening Value(previous Month Last Date) and Closing Value(Current Month) in QlikView

comparing Opening Value(previous Month Last Date) and Closing Value(Current Month)

chandra63 — Sat, 16 Nov 2024 19:20:46 GMT

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

chandra63 — Wed, 22 Jan 2020 09:20:24 GMT

Hi All,

Any suggestion. Please help us with this.

Thanks,

Chandra

Brett_Bleess — Wed, 05 Feb 2020 21:26:13 GMT

Chandra, have a look at the following Design Blog post, I believe it may give you a point in the right direction.

Regards,
Brett