Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
The #1 reason QlikView customers adopt Qlik Sense is a desire for a modern BI experience. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

How to calculate subtotal in straight table without using partial sum

Hi All,

 

I have the attached QlikView application.

 

I need to populate a straight table as following:

 

ScreenShot208.jpg

However, i am struggling to populate the highlighted column without using partial sum.

 

Can someone in the group share some light or guide me to the right direction?

 

Thanks in advance!

 

Elim

1 Solution

Accepted Solutions
Highlighted
MVP & Luminary
MVP & Luminary

Re: How to calculate subtotal in straight table without using partial sum

Hi,

 

Try below expression.

Sum(TOTAL<ID> value)

 

Regards,

Kaushik Solanki

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".

View solution in original post

2 Replies
Highlighted
MVP & Luminary
MVP & Luminary

Re: How to calculate subtotal in straight table without using partial sum

Hi,

 

Try below expression.

Sum(TOTAL<ID> value)

 

Regards,

Kaushik Solanki

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".

View solution in original post

Highlighted
Contributor
Contributor

Re: How to calculate subtotal in straight table without using partial sum

Thank you very much!

 

Resolved.

 

Elim