Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

jpapador
Valued Contributor

ALL Command

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.

InvoiceDescription
1A
1B
1C
2F
2B
2C
1 Solution

Accepted Solutions
Not applicable

Re: ALL Command

try this

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

4 Replies
er_mohit
Honored Contributor II

Re: ALL Command

Try This

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


Highlighted

Re: ALL Command

See attached example.


talk is cheap, supply exceeds demand
Not applicable

Re: ALL Command

try this

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

jpapador
Valued Contributor

Re: ALL Command

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

Community Browser