Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

how to sum multiple rows below - pivot table

I need to make a table  with the total billed value on YearPeriod x

this is a start, i need to translate this afterwards in payed days in adition to the costs (work in progress)

DCYearPeriodtotalrow below  WANTEDVALUE
europeTotal-17.879-
europe2013012-1.1981.614-17.879C3+E4
europe20130111.6143.311-16.681C4+E5
europe20130103.311279-18.296C5+E6
europe20130092791.457-21.607C6+E7
europe20130081.4577.752-21.885C7+E8
europe20130077.752-31.095-23.342C8+E9
europe2013006-31.0950-31.095C8+E10

how can i create  Wanted Value?

1 Solution

Accepted Solutions
Not applicable

Re: how to sum multiple rows below - pivot table

rangesum

(
below(
     
sum( {$<
     
YearPeriod= {">=1900001"}
>} WIP)*-1,
0,
noofrows()-rowno())
)

found it out, solution was on  : noofrows()- rowno()

1 Reply
Not applicable

Re: how to sum multiple rows below - pivot table

rangesum

(
below(
     
sum( {$<
     
YearPeriod= {">=1900001"}
>} WIP)*-1,
0,
noofrows()-rowno())
)

found it out, solution was on  : noofrows()- rowno()

Community Browser