topic Getting sales sum according to year in QlikView

Getting sales sum according to year

Fri, 03 Apr 2015 08:25:43 GMT

Hello everyone,

I am quite new here and I am having a trouble by configuring my sales representation tab.

In one table for a first column I would like to sum one year's sales e.g. 2015 and in the other column other year's e.g. 2014.

My questions is: how the script should look like? I tried to write like Sum({[Fiscal Year]}[Sales Amount]), but it's not working.

Any suggestions?

p.s. Fiscal year variable I get from date and Sales amount I am getting from my database. They are calculated properly.

Re: Getting sales sum according to year

oknotsen — Fri, 03 Apr 2015 17:35:46 GMT

I suggest you make a chart, a Pivot Table to be exact, with [Fiscal Year] as a Dimension and sum([Sales Amount]) as expression.

I am guessing you want to see them for a 2nd Dimension, so also add that to the chart.

After you made the chart, click on the column with [Fiscal Year], hold your mouse button pressed and move your mouse around in the chart to the top-right. You might have to make some circles till the arrow points to the left. Let go of the mouse button and you should have achieved what you want.

Re: Getting sales sum according to year

ramoncova06 — Fri, 03 Apr 2015 17:52:57 GMT

you want to use set analysis for this check the following link

QlikView App: Dates, Date Ranges and Set Analysis

Re: Getting sales sum according to year

oknotsen — Fri, 03 Apr 2015 17:58:05 GMT

No, I do not want to use Set Analysis for this .

But I am guessing you intended to reply to tapovilait .

In that case, this could be the expression for the column with 2015:

= Sum({ < [Fiscal Year] = {2015} >} [Sales Amount])