topic Re: New table with design value in QlikView

New table with design value

Thu, 12 May 2016 08:30:35 GMT

Hi All !

I have the following table:

I need to create a new table with the calculation of Total Volume = Volume(where RouteLineNumber -1) - Volume(unload) + Volume(load)

The final result for example above should be:

Does anybody have some ideas how to manage the calculus?

Thanks a lot in advance for help!

swuehl — Thu, 12 May 2016 13:44:24 GMT

Try a chart with your three dimensions (RouteString, TerminalName, RouteLineNumber) and as expression:

=Rangesum(

Above(TOTAL Sum({<OperationName = {'LOAD'}>} Volume),0,rowno(TOTAL)),

- Above(TOTAL Sum({<OperationName = {'UNLOAD'}>} Volume),0,rowno(TOTAL)),

)

Fri, 13 May 2016 08:27:30 GMT

Thanks a lot!