topic Re: Disabling partial sums shown in Qlik Sense Table in App Development

Disabling partial sums shown in Qlik Sense Table

abe786 — Wed, 05 May 2021 15:31:32 GMT

I had converted a Qlikview App using Qlik Sense converter. The straight tables which are converted are showing Partial Sums as shown in screenshot, is there any way to disable them?

So far, I tried disabling the Total function for the measure, however it also also gets rid of grand total apart from sub totals which I don't want.

I noticed if I create a fresh table from scratch in Qlik Sense, no such issue is observed.

I wanted to use the converted table only and not create it from scratch as actual table has 100's of dimension with show/hide condition which will take lot of effort.

Re: Disabling partial sums shown in Qlik Sense Table

Dalton_Ruer — Mon, 10 May 2021 15:51:25 GMT

Scroll down in the measure and change the Totals Function to None.

Re: Disabling partial sums shown in Qlik Sense Table

abe786 — Mon, 10 May 2021 19:44:46 GMT

Hi Dalton,

Like I mentioned in original post "So far, I tried disabling the Total function for the measure, however it also gets rid of grand total apart from sub totals which I don't want."

Anyway, I had found a solution i.e. by converting the affected table to pivot table and converting it back to table fixes this issue.