Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Not applicable

How to index data in a chart

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

Tags (1)