ALL Command

[jpapador]

What I am trying to do is have QV show me the invoice price when description = 'A' but instead of just showing me 1 - A, I want it to show me all it's description values.  In the set analysis I currently have Sum({$<Description ={'A'}>}Price).  So essentially I am looking for something like if invoice has a value of A in description, show me all it's description values.

Invoice	Description
1	A
1	B
1	C
2	F
2	B
2	C

[er_mohit]

Try This

Sum({$<Description =P({1<Description={'A'}>})>}Price)

[Gysbert_Wassenaar]

See attached example.

[#4 · Accepted solution]

try this

Sum({$<Invoice =P({1<Description={'A'}>}Invoice)>}Price)

[jpapador]

Thank you very much.  I'm very curious about what that syntax actually means though.