Current Month Vs Last Month

mahitham — Wed, 25 Nov 2020 16:16:04 GMT

Hi Experts,

Can any one please help me on below requirement.

I have Current Year Vs Previous Year(2018 Vs 2017) KPI with expressions like below.

Current Year = Count({<Year = $(=Max(Year))}>}ID)

Previous Year = Count({<Year = $(=Max(Year)-1)}>}ID)

here we have one more filter like Month first user will filter year suppose if he selects 2017 then kpis is showing 2017 vs 2016 after that if he filter Feb on Month filter it has to show 2018 Feb Vs 2017 Jan.

Please let me know is this possible to implement in Kpi.

Thanks in advance.

Re: Current Month Vs Last Month

Anonymous — Tue, 19 Jun 2018 05:58:23 GMT

Hi,

Perhaps something like this:

Current Year = Count({<Year = $(=Max(Year))}>}ID)

Previous Year = Count({<Year = $(=Max(Year)-1)}, Month = {$(=max(period)-1)}>}ID)

topic Re: Current Month Vs Last Month in QlikView

Current Month Vs Last Month

Re: Current Month Vs Last Month