Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
pkukkonen3
New Contributor II

Turnover from customers who are growing

I was asked to make an expression which calculates sales from customers who are growing compared to last year (and for the ones who are dropping as well).

I have already a expression which compares the results from Current Year to Last Year (see below) . How should I proceed from this?

Sum(salesprice)-Sum({<[Calendar.Year]= {"$(=max([Calendar.Year])-1)"}>}salesprice)

2 Replies
Highlighted

Re: Turnover from customers who are growing

Where are you trying to do this? If this is in chart, do you have customer as your dimension?

Highlighted
pkukkonen3
New Contributor II

Re: Turnover from customers who are growing

I'm trying to do this in table.

And yes, Customer Name is one of the dimensions.

I started wondering if it's even possible to display sales in way I described in the first post.