Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

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

Highlighted
elim
New Contributor

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

Thank you very much!

 

Resolved.

 

Elim