topic Re: Summing in QlikView

Summing

dhanavindhan — Mon, 26 Feb 2018 05:03:37 GMT

Hi Experts,

I want to calculate the total from previous column and concatenate the same with next column. I don't know how to write expression for this in Qlikview.

Pls help.

In above the KRPUS total voyage is 65. On CNSHA i want to add the previous total and current total. Like 65+22+10=97. How to write the expression for this scenario?

Thanks in Advance,

Dhana R

Re: Summing

jonathandienst — Mon, 26 Feb 2018 05:10:32 GMT

I do not properly understand your requirements. Do you mean specifically those three cells? How is that that related to the "total from the previous column" and "the next column". I think more example and a more detailed description might help.

Re: Summing

dhanavindhan — Mon, 26 Feb 2018 05:27:10 GMT

I just wanted to add the previous (Total Voyage) with Current(Total Voyage)

Example:

in my Previous total voyage i get (65)

Next i add Pilot to Pilot + Steaming + 65 = 97

Like above i wanted to do the calculation. Portcode is the common column for all this.

Re: Summing

jonathandienst — Mon, 26 Feb 2018 05:31:42 GMT

Are the columns individual expressions or a dimension?

(This is why small examples are always helpful).

Re: Summing

dhanavindhan — Mon, 26 Feb 2018 05:41:47 GMT

Individual expressions

Re: Summing

jonathandienst — Mon, 26 Feb 2018 05:55:06 GMT

There is no generic "previous" for individual expressions. You will have to identify each cell specifically. If you want more help, I recommend that you post a small sample app with some representative data and the table in question.