Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ederleelefon_gt
Partner - Contributor III
Partner - Contributor III

Qlik Sense Partial sum per specific category in Straight Table

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

!Straight Table Partial Sums.png

Thanks in Advance!

1 Solution

Accepted Solutions
vkish16161
Creator III
Creator III

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.

View solution in original post

8 Replies
YoussefBelloum
Champion
Champion

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 ?

ederleelefon_gt
Partner - Contributor III
Partner - Contributor III
Author

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

Is there any other way to replicate the format above?

TIA

YoussefBelloum
Champion
Champion

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

YoussefBelloum
Champion
Champion

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

vkish16161
Creator III
Creator III

Lee,

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

Image result for qlikview pivot table partial sum

vkish16161
Creator III
Creator III

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

ederleelefon_gt
Partner - Contributor III
Partner - Contributor III
Author

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

vkish16161
Creator III
Creator III

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.