topic Re: Sales comparision in QlikView

Sales comparision

Wed, 25 Nov 2020 16:16:04 GMT

Hello,

i want to create a sales comparision of years. I have the table with the columns company, year (2014-2017) and the sales amount.

Now i want to create a KPI dashboard which shows me the percentage of the change of the sales amount from the last to the year i select in the listbox.

Could someone help me and give me a formula for that? I have not found anything fitting to this issue now.

Thanks!

Re: Sales comparision

sunny_talwar — Thu, 29 Jun 2017 16:40:15 GMT

May be like this

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

Re: Sales comparision

sunny_talwar — Thu, 29 Jun 2017 16:40:54 GMT

Or may be this

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

Re: Sales comparision

Fri, 30 Jun 2017 08:10:35 GMT

It doesn´t work for the year i pick in the list box. It just stays the maximum year

Re: Sales comparision

sunny_talwar — Fri, 30 Jun 2017 11:11:15 GMT

Would you be able to share a sample where it is doing this? I would love to see if Max(Year) doesn't change with selections