topic Re: Chart Calculation in QlikView

Chart Calculation

Anonymous — Tue, 16 Sep 2014 14:14:07 GMT

Hi All,

Need to achieve the below Calculation from the chart level:

Col1 and Col2 are input fields.

Output Column is the Output expected

Calculation Column tells the way the Output should be calculated.

Could anyone help in solving this issue?

Thanks in advance.

maxgro — Tue, 16 Sep 2014 14:42:04 GMT

maybe in a straight table

dimension

Col1

expression

Col1 * rangesum(above(sum(Col2),0,rowno()))

Anonymous — Tue, 16 Sep 2014 14:48:59 GMT

You need the triangular number of col2 * Col1

The formula for triangular numbers is (n*(n+1))/2

so your expression will need to sum(((Col1*(Col1+1))/2)*Col2)

Tue, 16 Sep 2014 18:02:13 GMT

Output=Col1*Col2*(Col2+1)/2

Easiest way i guess