Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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

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?

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.

Community Browser