# New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
cancel
Showing results for
Did you mean:
Contributor III

## Sales growth based on filtered year or month

Hello everyone,

I have been using the formula Sum([Sales])/Above(Sum([Sales)-1 to plot sales growth on a year-month x axis line chart. Now I want to introduce a KPI box which shows the growth rate of sales of the filtered month (compared to the previous month). can you help me on how to do that ?

Here based on the filter of year/month the sales Growth should show instead of a -.

Edit1:

I am willing to change the year+month filter to year.month single filter if what I am sking is not possble in Qlik.

Thanks

Labels (2)

• ### SaaS

7 Replies
Partner - Master III

hi

do you want to calculate the sales growth for the entire period vs previous period ?

or the last month in the period ?

MVP

I see that you have the fields Year and Month but do you have any field that implies which YearMonth the transaction is?

Contributor III
Author

Hi Lironbaram

If possible would love it if you can show both the methods as I am currently not sure what would be best for my dashboard.

Contributor III
Author

Hi Vegar,

Yes the filters I have kept are one year and one month. Although I do have a year.month column in my auto calendar.

Contributor III
Author

Hi Lironbarom,

Further clarification. So if I select year = 2020 and month = january then the comparison should be between it and 2019, January. If I select year 2019 and month April+May then the growth should be compared to 2018, April+May.

Hope this clarifies the confusion.

MVP

@Test101  I read your conversation with @lironbaram  and do no longer think you will need your yearmonth field.  Try this expression: sum({< Year={'\$(=max(Year))'}>} Sales)/sum({< Year={'\$(=max(Year)-1)'}>} Sales)

See attached qvf

Contributor III

there is not vaue here ?