topic Re: Qlik Sense Partial sum per specific category in Straight Table in QlikView

Qlik Sense Partial sum per specific category in Straight Table

ederleelefon_gt — Wed, 18 Apr 2018 12:34:12 GMT

Hi Qlik Enthusiast!,

I would just like to know, if you had any ideas for Partial Sum in Qlik Sense Straight table for a specific Column,

Please see picture below

Thanks in Advance!

Re: Qlik Sense Partial sum per specific category in Straight Table

YoussefBelloum — Wed, 18 Apr 2018 12:56:54 GMT

Hi,

the is no partial sum on the straight table, but you can use set analysis to solve this.

did you use set analysis before ?

Re: Qlik Sense Partial sum per specific category in Straight Table

ederleelefon_gt — Wed, 18 Apr 2018 13:44:23 GMT

Hello, what I mean is apply the same format of the above report.

Is there any other way to replicate the format above?

TIA

Re: Qlik Sense Partial sum per specific category in Straight Table

YoussefBelloum — Wed, 18 Apr 2018 13:54:04 GMT

with the object properties, you can't, but one way to do this is maybe using expressions with set analysis and valuelist on the dimension

Re: Qlik Sense Partial sum per specific category in Straight Table

YoussefBelloum — Wed, 18 Apr 2018 13:58:04 GMT

would you be able to attach sample data to be able to test what I suggested above ?

Re: Qlik Sense Partial sum per specific category in Straight Table

vkish16161 — Wed, 18 Apr 2018 14:07:20 GMT

Lee,

A "P&L" format table is not possible in straightforward way. Pivot table in QlikView has a partial sums option.

Re: Qlik Sense Partial sum per specific category in Straight Table

vkish16161 — Wed, 18 Apr 2018 14:08:14 GMT

If you're o.k. with showing partial sums in another column, you can use the TOTAL qualifier.

Re: Qlik Sense Partial sum per specific category in Straight Table

ederleelefon_gt — Thu, 19 Apr 2018 06:16:31 GMT

Hi Vishnu,

Thank you for your answer although, I think in Qlik Sense there is no option for Partial Sums yet.
Might took a while to update it. But Im hoping they will include it, since many Qlik View clients planned to migrate to Qlik Sense, but in terms of functionality QlikView still offers a lot, other than QLik Sense

Regards,

Lee

Re: Qlik Sense Partial sum per specific category in Straight Table

vkish16161 — Thu, 19 Apr 2018 12:01:26 GMT

For your requirement,

You can create a separate column and use the total qualifier. Like so,

Sum(total <[Merchandise Category]> [Net Sales]).

This will create a separate column showing partial sums.