topic Re: Set Analysis - Compare Sales Amount with Sales Amount year before in QlikView

Set Analysis - Compare Sales Amount with Sales Amount year before

Anonymous — Thu, 29 Mar 2018 07:07:31 GMT

Hi all,

I have a question about set analysis.
I have a Pivot Table where I have evaluated my Sales Amount in month and years.
Next I will create another column where I can see my Sales Amount the year before (Sales Amount YB).
In column Sales Amount I have the correct data, but I didn't have the Sale Amount among themselves.
But will compare the actual Sales Amount with my Sales Amount the year before side by side.

(So I need a formula for column "Sales Amount YB")
See an example below.

I tested following example:

Sum({$<Year={$(=Max(Year)-1)}>}[SalesAmount])

But it didn't work.
I hope you can help me.

I'm a beginner in Qlik View, so I don't know Qlik View very well and sorry my englisch is not so good.
Thanks for your help.

Re: Set Analysis - Compare Sales Amount with Sales Amount year before

sunny_talwar — Thu, 29 Mar 2018 14:42:57 GMT

I would suggest you to look into

The As-Of Table

Alternatively, you can try with Above()/Below() functions

Below(Sum(SalesAmount), 12)

Re: Set Analysis - Compare Sales Amount with Sales Amount year before

wdchristensen — Thu, 29 Mar 2018 16:00:46 GMT

Might also check out this example from https://www.quickintelligence.co.uk/examples/

QlikView App: Set Analysis - Prior Period Comparison