Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
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