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-least-by-most-qlikview-developers/
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
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?