topic Re: sum per line in QlikView

sum per line

kkarlste — Tue, 16 May 2017 18:49:52 GMT

Have you any iedeas sum per line

EU-COMPINED * LITRES = Sum per line ^ 100

Re: sum per line

Digvijay_Singh — Tue, 16 May 2017 19:35:00 GMT

Didn't understand, what do you get if you simply take EU-Combined and Litres as dimensions and there multiplication (or sum() of them multiplied) as expression? Another expression with last expression * 100?

Re: sum per line

kkarlste — Tue, 16 May 2017 19:43:29 GMT

Can you give example skript?

Re: sum per line

Digvijay_Singh — Tue, 16 May 2017 19:54:04 GMT

Data:

Load * inline [

"EU-COMBINED",LITRES

8.9,6077

8.9,61.3

8.9,52.88

8.9,59.47

8.4,47.18 ];

Final:

Load

"EU-COMBINED",LITRES,

Sum("EU-COMBINED")*Sum(LITRES) as SumPerLine,

Sum("EU-COMBINED")*Sum(LITRES)*100 as "SumPerLine*100"

Resident Data

Group By "EU-COMBINED",LITRES

;

Drop table Data;

But you can calculate the expression in the straight table in UI directly.