Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
elim
New 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

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

Hi,

 

Try below expression.

Sum(TOTAL<ID> value)

 

Regards,

Kaushik Solanki

2 Replies

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

Hi,

 

Try below expression.

Sum(TOTAL<ID> value)

 

Regards,

Kaushik Solanki

elim
New Contributor

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

Thank you very much!

 

Resolved.

 

Elim