Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

How to create a Index Chart?

Dear Colleagues,

I'm trying to create a Index chart (base 100) .

The expression "First" work fine for the pivot table but it is not working in the Line chart.

Index table:

Supplier201120122013201420152016
a100101102103104105
b1009998989796
c100109118127136145


Data table:

Supplier201120122013201420152016
a110111112113114115
b120119118117116115
c110120130140150160


Basically the calculation I want to reproduce in the Line chart is the results of the current year divided by the first year.

Could somebody help me to find the better expresion to create the Line chart? Any good solution would be welcome!

Please find enclosed the example I'm using.

Thanks in advance,

Leandro Duarte

Tags (2)
1 Solution

Accepted Solutions
matt_crowther
Valued Contributor

Re: How to create a Index Chart?

Leandro,

I've written about Indexed Charts on my blog: http://qvdesign.wordpress.com/2012/05/09/the-indexed-time-series-chart-the-forgotten-technique-at-le...

It includes a .qvw and a 'how to' so it may help you.

I love Indexed Charts - let's get them used more in Qlikview!

All the best,

Matt - Visual Analytics Ltd

Qlikview Design Blog: http://QVDesign.wordpress.com

@QlikviewBI

3 Replies
Not applicable

Re: How to create a Index Chart?

first expression will not work in line chart

try to do it this way:

sum(Data)    /  above(sum(Data),rowno()-1) *100

matt_crowther
Valued Contributor

Re: How to create a Index Chart?

Leandro,

I've written about Indexed Charts on my blog: http://qvdesign.wordpress.com/2012/05/09/the-indexed-time-series-chart-the-forgotten-technique-at-le...

It includes a .qvw and a 'how to' so it may help you.

I love Indexed Charts - let's get them used more in Qlikview!

All the best,

Matt - Visual Analytics Ltd

Qlikview Design Blog: http://QVDesign.wordpress.com

@QlikviewBI

aresende
New Contributor II

Re: How to create a Index Chart?

Hi, Matt, nice how to!

Anyway, I have a bit of a complication in this matter.

My "year" dimension have a segments "sub-dimension". Using your guide I'm able to create monthly indexes for all segments.

My problem is that my segments are seasonally affected, so they behavior weirdly within a year period, so I wanted to do indexes based on the YTD calculation (this way my entire base year would be "100", and only in january of the next year it would change, doing monthYTD/basemonthYTD.

If i remove the "TOTAL <Segments>" part of my bottom equation and change the if statement to the base year, All my segments go to 100 to the year 1, but no other years are available.

Do you have any suggestion?

Thanks!

Community Browser