Problem with dynamic dimension in a line-graphic

[peterwh]

Hello,

I have the following problem: In a normal Qlikview-table I can calculate the cumulated duration as formula by "rangesum(above(total (fabs(duration)), 0, NoOfRows(total)))". Now I want this values as x-axis for a line-graphic. Is this possible, because I only get "error in dynamic dimension" and I don't know how to change the formula to get it to work. I've played with the aggr-function, but I hadn't success so far.

Background:
I have a table with durations of different temperatures for an article and I want a diagram which shows the resulting temperaturecurve. If I use the PosNr as x-axis the curve is visible, but I need the acc. durations as x-axis.

Table:
PosNr Duration Temperature Acc.duration (formula: rangesum(above(....))
1 5 30 5
2 7 100 12
3 3 50 15
4 2 20 17

The temperaturecurve should be:
at 5 -> 30
at 12 -> 100
at 15 -> 50
at 17 -> 20

QV-Version: 9 SR3

I hope I explained my problem good, if not feel free to ask.

Thanks in advance
Peter

[#2 · Accepted solution]

Hi,

You formulae should be

=aggr(rangesum(above(Duration,0,rowno())),Duration)

Check the attached application.

- Sridhar

[peterwh]

Hello Sridhar,

your formula and your example worked, but I've had to change the second "duration" to PosNr, because with the original data it didn't work correctly.

To complete our chart I had to add a second dimension to the aggr-function, because PosNr is not unique only with "Pass" as second key, so now we can get a second curve in the same chart.

Thanks for your help and the example.

I've attached my changed version, if someone wants to see the "extended" version.

Peter