topic Re: ALL Command in QlikView

ALL Command

jpapador — Tue, 07 May 2013 19:04:31 GMT

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

Re: ALL Command

er_mohit — Tue, 07 May 2013 19:15:34 GMT

Try This

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

Re: ALL Command

Gysbert_Wassenaar — Tue, 07 May 2013 19:18:16 GMT

See attached example.

Re: ALL Command

Tue, 07 May 2013 19:55:03 GMT

try this

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

Re: ALL Command

jpapador — Wed, 08 May 2013 18:47:40 GMT

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