Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
Scroll down in the measure and change the Totals Function to None.
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.