Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Constant value in dimension chart

Hi,

I am a very new user of Qlik Sense. Right now I am working on a way to create a Duration curve chart (something similar to this : http://hydrofuture.weebly.com/uploads/2/6/8/5/26855805/sfdasd.jpg). To do so, I am following this tutorial : OSU Streamflow Tutorial - Flow Duration Analysis.

The problem that I have is that I want to create a line chart with the following dimension :

100*(aggr(Rank(Measure,1,1),Dimension))/(XXXXXX+1)

And I want the XXXXXX to be the maximal rank of my measures. It is supposed to be, for a given selection with my filter panes, a constant value. However, I have tried few things and I've observed that having a constant expression in a chart dimension seems to be impossible. For example, I can't choose max(aggr(Measure,Dimension)) as a chart dimension. So is it possible to compute XXXXXX to be the maximal rank of my measure (so the rank of the lowest value of my measure) such as it is a constant value for a given selection ?

Best regards,

Tags (1)