topic Re: Month on Month % calculation in QlikView

Month on Month % calculation

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

Hi,

We need to do a month on month % calculation.

Logic: 2017 sales-2018 sales/2018sales

I need to get this in front end expression.

Please let me know how to get this.

Attached is the sample datasource.

Thanks..

Re: Month on Month % calculation

Anonymous — Fri, 20 Apr 2018 08:30:39 GMT

Hi,

Perhaps the following will give a good start:Current Years Current Month Vs Last Year Same Month Data

Re: Month on Month % calculation

nareshthavidishetty — Fri, 20 Apr 2018 09:18:23 GMT

Please share the logic.I have tried but its not working.

Thanks..

Re: Month on Month % calculation

niclaz79 — Fri, 20 Apr 2018 09:21:41 GMT

(Sum({<Year = {$(=Max(Year)-1)}>}sales)-Sum(sales) ) / Sum(sales)

Works, considering you have a selected year (2018 for instance) and month.

Re: Month on Month % calculation

nareshthavidishetty — Fri, 20 Apr 2018 09:31:16 GMT

Hi,

Please find below .

I need to show some thing like this.

Thanks..

Re: Month on Month % calculation

niclaz79 — Fri, 20 Apr 2018 09:50:20 GMT

Hi,

Using your example data and

Dimension : Month

Expression 1: Sum(Sales)

Expression 2: (Sum(Sales) - Sum({<Year = $(=Max(Year)-1)>}Sales) )/ Sum(Sales)

Selection: Year = 2018

I get this:

Re: Month on Month % calculation

nareshthavidishetty — Fri, 20 Apr 2018 10:35:29 GMT

Hi,

I need to show with out selection.

Thanks..

Re: Month on Month % calculation

vishalarote — Fri, 20 Apr 2018 10:36:09 GMT

Try this Expression

(sum({<Year={'2017'}>}Sales)-sum({<Year={'2018'}>}Sales))/sum({<Year={'2018'}>}Sales)

Re: Month on Month % calculation

vishalarote — Fri, 20 Apr 2018 10:59:05 GMT

Some Changes Above Expression PFA

e.g SC:

Re: Month on Month % calculation

vishalarote — Fri, 20 Apr 2018 11:20:25 GMT

Sorry by Mistake i am Sending Empty QVW

PFA

Re: Month on Month % calculation

sasiparupudi1 — Fri, 20 Apr 2018 12:37:35 GMT

Try