Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. 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

Highlighted
Creator
Creator

Thank you so much Vegar!

 

-BC

Highlighted
Creator
Creator

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