topic Staright table to show current year and previous year sales in QlikView

Staright table to show current year and previous year sales

Mon, 29 Feb 2016 22:24:09 GMT

Hi,

Is it possible to show sales for a year and sales for the previous year in a straight table without using above() function?

My data is like:

Year, Sales

2011, 1000

2012, 2000

2013, 3000

2014, 4000

2015, 5000

And I want the chart to look like

Year, Sales, Previous_Year

2011, 1000,

2012, 2000, 1000

2013, 3000, 2000

2014, 4000, 3000

2015, 5000, 4000

I was able to achieve it using above() function but when filters are applied (like when only few years are selected, the first one is always missing Previous_Year value), the above() is not working as expected.

Attaching a sample file. Any help would be greatly appreciated.

Re: Staright table to show current year and previous year sales

Tue, 01 Mar 2016 00:22:10 GMT

Hi,

If anyone is interested, I was able to achieve this with a bit of scripting code. Sample attached.

-- Malai !

Re: Staright table to show current year and previous year sales

sunny_talwar — Tue, 01 Mar 2016 00:35:24 GMT

I know you found your solution, but just so you want the Above function solution, you can use this expression:

If(Sum(Sales) > 0, Above(Sum({<Year>}Sales)))

Re: Staright table to show current year and previous year sales

Tue, 01 Mar 2016 00:44:52 GMT

Your expression works as expected. Thanks a lot! This is actually better than my solution and that made life easier for me