Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
tester_sogeti
Contributor

YoY chart

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

1 Solution

Accepted Solutions
MVP
MVP

Re: YoY chart

Like this?

Capture.JPG

CY = Sum(Value)

Increase = Above(CY)-CY

7 Replies

Re: YoY chart

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
MVP
MVP

Re: YoY chart

Like this?

Capture.JPG

CY = Sum(Value)

Increase = Above(CY)-CY

tester_sogeti
Contributor

Re: YoY chart

Yes i think is that! I am checking it!

Thank you very much!

tester_sogeti
Contributor

Re: YoY chart

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

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 )

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
MVP
MVP

Re: YoY chart

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)

tester_sogeti
Contributor

Re: YoY chart

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

Thank you for the help!