How to index data in a chart

Tue, 17 Aug 2010 11:53:14 GMT

Hi all,

Still a freshman in Qlikview, so don´t mind me for asking the easy questions 😉

I am trying to set up a histogram chart with annual data (T=1 to T=3) for two expressions.

What I would like to do is to scale the expressions where with the value for T=1 equal to 100.

Currently I try to use the following set analysis:

code =Sum({<Dimension1={'Value'}>} Fact1)/Sum({<Dimension1={'Field1'}, Year={$(=Min(Year))}>} Fact1) /code

This results however in a chart only for T=1 (and not the desired T=1 to T=3).

Any suggestions? A link to a set analysis handbook would help as well!!

Kind regards

topic How to index data in a chart in QlikView