# 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...

Tags (1)
1 Solution

Accepted Solutions
MVP

## 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
MVP

## Re: Calculating column percentage with 2 identifiers

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

MVP

## 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!

MVP

## Re: Calculating column percentage with 2 identifiers

Di niente Irene ... buon lavoro!