Discussion board where members can get started with QlikView.
I would like to create a straight table based on the example data in the excel file. The condition is mentioned in the excel file. I need to calculate the sum of Amounts only for the red marked IDs and Type field.
Can I rephrase your condition to this?
Calculate the sum amount but exclude all amount for the IDs that is associated with type B.
If so then try this expression.
View solution in original post
Thank you so much Vegar!