topic Re: Compare selected years sales with previous years sales in QlikView

Compare selected years sales with previous years sales

Anonymous — Fri, 02 Feb 2018 13:16:10 GMT

Hi,

I have a table like Salesdate,product_id,Total. I added a KPI and want to show Selected Years Sales and and previous years sales.

I added a field tom my sheet to select the year.(salesdate.year).

What should be in expression of the kpi data.

Regards.

Re: Compare selected years sales with previous years sales

Anil_Babu_Samineni — Sun, 04 Feb 2018 01:42:34 GMT

Create Field like

Load Salesdate,

product_id,

Total,

Year(Salesdate) as salesdate.year

From Table;

Then, Measure looks like this?

='Current Year ' & Sum({<salesdate.year = {'$(=Max(salesdate.year))'}>} Total) & Chr(10) & 'Previous Year ' & Sum({<salesdate.year = {'$(=Max(salesdate.year-1))'}>} Total)

Re: Compare selected years sales with previous years sales

Anonymous — Wed, 07 Feb 2018 12:12:20 GMT

I have created a filed in Sales table like year which is the year of the sales_date.

I have 2 KPI's now. both have different measurment. but the results are the same.

Re: Compare selected years sales with previous years sales

Anonymous — Thu, 08 Feb 2018 11:39:21 GMT

Results are the same.

Re: Compare selected years sales with previous years sales

ElizaF — Thu, 08 Feb 2018 17:21:30 GMT

The solution that provided by Anil is correct, with the observation that the correct expression is:

='Current Year ' & Sum({<salesdate.year = {'$(=Max(salesdate.year))'}>} Total) & Chr(10) & 'Previous Year ' & Sum({<salesdate.year = {'$(=Max(salesdate.year)-1)'}>} Total)

Re: Compare selected years sales with previous years sales

Anonymous — Fri, 09 Feb 2018 07:29:41 GMT

Still the same result. I'm selecting the year from the field I added to my sheet which is Saledate.year. Is there something wrong with it? Logically this expression should work but it's n ot

Re: Compare selected years sales with previous years sales

Anonymous — Wed, 11 Apr 2018 01:27:58 GMT

Hi,

Create these variables:

vCurrentYear = Max(Year)

vPreviousYear = Max(Year-1)

vCurrentTotal = Sum({<Year={$(vCurrentYear)}>}Total)

vPreviousTotal = Sum({<Year={$(vPreviousYear)}>}Total)

I hope this solve your problem