Rangesum before total is not coming

infosense_devel — Thu, 07 Jun 2018 08:10:49 GMT

Hello,

I have a pivot table, in which there are three dimension like SBU, Territory, Salesperson and month (month has partial sum ticked in Presentation tab)

and there are some expressions like MTD,PYTD,MTD VS MTD % and YTD vs PYTD%

I have pick up Month dimension and pivoting it in rows like below:

In YTD Vs PYTD % I have applied expression as per below and its result comes fine

but when I see into Total column its shows me dash '-' like below:

If anyone have any idea about these problem.

Please help me to resolve it.

Thanks.

Re: Rangesum before total is not coming

marcus_sommer — Thu, 07 Jun 2018 08:41:42 GMT

Maybe you need an aggr() around your expression like:

sum(aggr(YourExpression, Dim1, Dim2, ...))

- Marcus

topic Rangesum before total is not coming in QlikView

Rangesum before total is not coming

Re: Rangesum before total is not coming