topic how to get current month and date count details based on user selection in QlikView

how to get current month and date count details based on user selection

gyuvaraj — Fri, 15 Nov 2024 23:45:39 GMT

Hi All,

I am trying to get the Daily and Month to date(MTD) count, Here i got results for current day and current month count but when user is selected previous month its not showing data in KPI.

For example:

max date -15/10/2020
max month - Oct

KPI's:

Daily - 60

Month - 180

Here when user is selected previous month(SEP) in calendar the KPI's shows - (dash) in text object am expecting here it should show the SEP month max date count in daily and total SEP month count in MTD.

Thanks in advance

Regards,

Yuvaraj

Re: w to get current month and date count details based on user selection

Chanty4u — Thu, 22 Oct 2020 09:15:43 GMT

is this?

Count({$<Month = {"$(=Month(Today()))"}>} ID)

Count({<Date = {"$(='>=' & Date(MonthStart(Today()), 'DD/MM/YYYY') & '<' & Date(MonthStart(Today(), 1), 'DD/MM/YYYY'))"}>} ID)

Re: w to get current month and date count details based on user selection

gyuvaraj — Thu, 22 Oct 2020 09:29:16 GMT

Hi,

Thanks for your reply.

Its working fine for Oct month when i choose Sep its not showing any count.

Re: how to get current month and date count details based on user selection

MayilVahanan — Thu, 22 Oct 2020 09:33:01 GMT

Hi @gyuvaraj

Try like below

For Daily: Sum({$<Date= {"$(=Date(Max(Date),'DD/MM/YYYY'))"}>} Sales)

For MTD: Sum({<Date = {"$(='>=' & Date(MonthStart(Max(Date)), 'DD/MM/YYYY') & '<=' & Date(MonthEnd(Max(Date)), 'DD/MM/YYYY'))"}>} Sales)