topic Problem with dynamic dimension in a line-graphic in QlikView

Problem with dynamic dimension in a line-graphic

peterwh — Thu, 22 Apr 2010 07:52:36 GMT

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

Problem with dynamic dimension in a line-graphic

Thu, 22 Apr 2010 08:30:55 GMT

Hi,

You formulae should be

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

Check the attached application.

- Sridhar

AW:Re: Problem with dynamic dimension in a line-graphic

peterwh — Wed, 28 Apr 2010 09:31:45 GMT

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