topic Re: calculating straight table total in QlikView

calculating straight table total

engr_farhanqadr — Thu, 30 Oct 2014 18:11:43 GMT

Dear Folks,

I have designed a straight table in which I have column Total Values

where i have sum up different columns which are WH value , In Transit value and Fba Stock value by adding their expression labels but the values are not shown at respective rows and total at header is also wrong.

please correct me where I am wrong.

Attached is the file.

Regards,

Farhan.

Re: calculating straight table total

Thu, 30 Oct 2014 20:35:40 GMT

Use the below to calculate Total Value.

=Alt([WH Value],0)+Alt([In Transit Value],0)+Alt([FBA Stock Value],0)

Re: calculating straight table total

maxgro — Thu, 30 Oct 2014 21:26:50 GMT

=rangesum([WH Value],[In Transit Value],[FBA Stock Value])

from online help

rangesum(expr1 [ , expr2, ... exprN ])

Returns the sum of a range of 1 to N arguments. As opposed to the + operator, rangesum will treat all non-numeric values as 0.

Re: calculating straight table total

engr_farhanqadr — Fri, 31 Oct 2014 21:53:18 GMT

Thanks srukmana.