topic Re: YoY chart in QlikView

YoY chart

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

Hi all,

I am trying to make a Year over Year chart. What i want to achive is a line chart with Year as dimension, and increase in value since last year as expression.

It looks like this:

TABLE

FACT:

LOAD * INLINE [

FISCAL_YEAR, VALUE

FY17, 2

FY17, 6

FY16, 5

FY16,14

FY15, 10

]

Chart

Dimension: FISCAL_YEAR

Expression: avg(VALUE ) - avg( { $1< FISCAL_YEAR= {'$(=vPrevious_year)'} > } VALUE )

Variable

'FY'&(Right(FISCAL_YEAR,2)-1)

It does not work, and i can't figure out why, the variable alone as expression with the FY as dimensions works fine. Do u have any tips?

Thank you,

PD. i provide some sample data and tables

Re: YoY chart

Anil_Babu_Samineni — Fri, 22 Dec 2017 09:01:41 GMT

My suggestion is this?

FACT:

LOAD *, Right(FISCAL_YEAR,2) as YEAR INLINE [

FISCAL_YEAR, VALUE

FY17, 2

FY17, 6

FY16, 5

FY16,14

FY15, 10

]

Chart

Dimension: FISCAL_YEAR

Expression: avg(VALUE ) - avg( { $1< FISCAL_YEAR= {'$(=vPrevious_year)'} > } VALUE )

Variable

Max(YEAR)-1

Re: YoY chart

tresB — Fri, 22 Dec 2017 09:07:13 GMT

Like this?

CY = Sum(Value)

Increase = Above(CY)-CY

Re: YoY chart

Anonymous — Fri, 22 Dec 2017 09:10:20 GMT

Yes i think is that! I am checking it!

Thank you very much!

Re: YoY chart

Anonymous — Fri, 22 Dec 2017 09:11:41 GMT

Not working, i belive that the reason is that FY17 is a string not a number, that why i was spillting it in my variable.

Thanks anyway!!

Re: YoY chart

Anil_Babu_Samineni — Fri, 22 Dec 2017 09:13:39 GMT

I don't have access, As my assumption the degrade should be YEAR only. For sure this should work until unless i am in different root

avg(VALUE ) - avg( { $1<YEAR= {'$(=vPrevious_year)'} > } VALUE )

Re: YoY chart

tresB — Fri, 22 Dec 2017 09:14:44 GMT

For some reason, I am not able to attach. You can just try as I suggested above.

CY is the first expression label. Or, you can try second expression as = Above(Sum(VALUE)) - Sum(VALUE)

Re: YoY chart

Anonymous — Fri, 22 Dec 2017 09:20:02 GMT

Yes it worked! Sorry i didnt see the expression below the graphic at the beginig.

Thank you for the help!