Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Calculating column percentage with 2 identifiers

Hi everyone, I have a little issue...

I must caluclate the percentage of the column, but considering two identifiers. the formula I'm using at the moment is


=Sum ([QTA 1 Ordini Cliente])/Sum (TOTAL <[Descrizione Linea]> [QTA 1 Ordini Cliente])

where <[Descrizione Linea]> is my identifiers. I should get something like that

=Sum ([QTA 1 Ordini Cliente])/Sum (TOTAL <[Descrizione Linea]> AND <Other identifier> [QTA 1 Ordini Cliente])


i have attached two pictures to exaplain a little better what I need, so I hope I have been clear enough...

1 Solution

Accepted Solutions

Re: Calculating column percentage with 2 identifiers

Try


Sum ([QTA 1 Ordini Cliente])/Sum (TOTAL <[Descrizione Linea],[Other identifier]> [QTA 1 Ordini Cliente])


Let me know

4 Replies

Re: Calculating column percentage with 2 identifiers

=Sum ([QTA 1 Ordini Cliente])/Sum (TOTAL <[Descrizione Linea],Other identifier> [QTA 1 Ordini Cliente])

Re: Calculating column percentage with 2 identifiers

Try


Sum ([QTA 1 Ordini Cliente])/Sum (TOTAL <[Descrizione Linea],[Other identifier]> [QTA 1 Ordini Cliente])


Let me know

Not applicable

Re: Calculating column percentage with 2 identifiers

thank you Alessandro Saccone! I was writing

=Sum ([QTA 1 Ordini Cliente])/Sum (TOTAL <[Descrizione Linea]>,<[Other identifier]> [QTA 1 Ordini Cliente])

I didn't realize both the identifiers must be within <>!


Many thanks!

Re: Calculating column percentage with 2 identifiers

Di niente Irene ... buon lavoro!

Community Browser