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