topic Re: Sales Variation Expression in QlikView

Sales Variation Expression

microwin88x — Wed, 25 Nov 2020 16:16:04 GMT

Hello,

I have the following table:

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 — Tue, 27 Sep 2016 19:39:37 GMT

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 — Tue, 27 Sep 2016 19:43:08 GMT

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

m_woolf — Tue, 27 Sep 2016 19:51:14 GMT

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

rupamjyotidas — Tue, 27 Sep 2016 19:52:26 GMT

Here is the example:

LOAD Year,

Sales,

[Previous Year Sales],

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

FROM

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

Tue, 27 Sep 2016 19:57:43 GMT

can u show ur script please