Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Set Analysis problem

Hi,

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.

clipboard_image_0.png

 

Thanks,

BC

Labels (1)
1 Solution

Accepted Solutions
Highlighted
Partner
Partner

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.

Sum({<ID=E({<Type={'B'}>}) [Aumount($)])

Plees ekskuse my Swenglish and or Norweglish spelling misstakes

View solution in original post

3 Replies
Highlighted
Partner
Partner

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.

Sum({<ID=E({<Type={'B'}>}) [Aumount($)])

Plees ekskuse my Swenglish and or Norweglish spelling misstakes

View solution in original post

Creator
Creator

Thank you so much Vegar!

 

-BC

Highlighted
Creator
Creator

Sum({<Type={'A'}>}[Amount($)])