Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Not applicable

Sales comparision

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!

4 Replies
Highlighted

Re: Sales comparision

May be like this

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

Highlighted

Re: Sales comparision

Or may be this

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

Highlighted
Not applicable

Re: Sales comparision

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

Highlighted

Re: Sales comparision

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