Sales Variation Expression

[microwin88x]

Hello,

I have the following table:

Year	Sales	Previous Year Sales	Sales Variation
2010	1800	-	-
2011	2100	1800	17%
2012	2300	2100	10%
2013	3000	2300	30%
2014	3250	3000	8%
2015	4000	3250	23%
2016	3500	4000	-13%

I created the expression Sales Variation with ABOVE function which is OK if I don't make any selection.

But when I select a year, I lose the value from Previous Year Sales:

Year	Sales	Previous Year Sales	Sales Variation
2014	3250	-	-

If you know any other way to do this, I'd really appreciate it.

Thank you!

[sergio0592]

Hi,

I think your chart is not build as a classical KPI should be built. Don't use above function, use two expressions:

Sales N : sales current year

Sales N-1 : sales previous year

and sales variation expression : ("Sales N"-"Sales N-1") / "Sales N-1"

[rupamjyotidas]

'Above' won't work when you make selection, best bet here is using 'Previous' or 'Peek' in Script

[m_woolf]

I think your percents are all wrong. See the attached qvw:

[rupamjyotidas]

Here is the example:

LOAD Year,

     Sales,

     [Previous Year Sales],

(     (Sales- Peek(Sales))/Peek(Sales))*100 as [Sales Variation]

FROM

[https://community.qlik.com/thread/234380]

(html, codepage is 1252, embedded labels, table is @1);

[#6]

can u show ur script please