topic Re: Calculation cumul in straight table in QlikView

Calculation cumul in straight table

Mon, 10 Dec 2012 14:39:22 GMT

Hi All,

I want to calculate the cumul of the 'person-year nieuwe diagnoses' in a straigth table. Can I do this in the front-end?

See the picture in attachement to get an idea of what I mean, that's easier than describing it all.

Thanks in advance!

Wouter

Re: Calculation cumul in straight table

Gysbert_Wassenaar — Mon, 10 Dec 2012 15:10:41 GMT

You can use the rangesum function in combination with the above function. See attached example.

Re: Calculation cumul in straight table

Mon, 10 Dec 2012 15:54:55 GMT

@Gysbert

thanks for the quick respons.

The data I am trying to accumulate is already the result of an aggregation.

Any ideas how to tackle this?

I tried this, but I can't get this formula to calculate.... (see also attachment)

=rangesum(above(sum($(vND))),0,RowNo())*Halfwaypoint

where vND = count(distinct {<NieuweDiagnoses={1}>}CumulID)

Thanks in advance

Wouter

Re: Calculation cumul in straight table

Gysbert_Wassenaar — Mon, 10 Dec 2012 17:53:02 GMT

Maybe like this. The most important bit is removing two dimensions, replacing them as a expressions. I've also calculated some counts in the script to simplify some of the expressions.

Re: Calculation cumul in straight table

Tue, 11 Dec 2012 08:28:36 GMT

Hello Gysbert,

Thanks for the reply.

I'm affraid that the simplification causes a loss of flexibility in the front. I want to add in a later stage for example a sex per ID (m/f). Then the calculation of the incidences should adapt itself to this selection. By doing the calculation in the background, this becomes impossible.

I appreciate your input, maybe you have some good advice on this point?

Thanks in advance!

Wouter

Re: Calculation cumul in straight table

Tue, 11 Dec 2012 09:16:17 GMT

Hello Gysbert,

After removing the dimension, and replacing them by an expression, with column(5) = PYNieuweDiagnoses, this does it:

=rangesum(above(total(column(5)),0,rowno()))

Thanks for the help!

Wouter