Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
spikenaylor1
New Contributor III

sum subtotal

Hi there

Below is my table

Bactch, Package ID, Inspected, Failed are all brought in from source data

I need to calculate for each batch the batch total

I cannot work out how to acheive this

any help or guidance would be gratefully appreciated

BatchPackage IDInspectedFailedBatch Total
ABC123A24801122323673 (=sum(Inspected for Batch))
ABC123A25689713523673
ABC123A26876519823673
ABC124Z222056226711
ABC124Y6773057236711
ABC124T5671598986711
Tags (2)
1 Solution

Accepted Solutions

Re: sum subtotal

May be this

Sum(TOTAL <Batch> Inspected)

View solution in original post

2 Replies

Re: sum subtotal

May be this

Sum(TOTAL <Batch> Inspected)

View solution in original post

spikenaylor1
New Contributor III

Re: sum subtotal

Thanks

very easy and simple

regards