topic Re: How to show row wise calculated value in pivot table in App Development

How to show row wise calculated value in pivot table

Aditya_Chitale — Sun, 24 Apr 2022 06:28:46 GMT

Hi everyone,

Is it possible to show row wise calculated value in qliksense pivot table ?

I have months as my dimension values(column). And added 3 measures namely: Target , SO Created and CRM Approved.

I want to show NRR (YTD Sum Total / count of total months) for all available months at the end of the table by adding an extra column

hic — Mon, 25 Apr 2022 13:15:16 GMT

Isn't this just a variant of an accumulation? If so, you should be able to do it with the Above function.

If you have Month as dimension (and the chart sorted by dimension) and Sum(Target) as measure, you can add a column

RangeSum(Above(Sum(Target),0,RowNo()))

to get the accumulated target value. And if you want this divided by # of months, you can do a

RangeSum(Above(Sum(Target),0,RowNo())) / RowNo()

vinieme12 — Tue, 26 Apr 2022 09:32:20 GMT

something like below

=sum(aggr( RangeSum(Above(Sum(somefield)/count(somefield),0,RowNo(total))) , (Month,(Numeric,ASCENDING))))