Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Column Percentage

I'm sure I'm writing wrong this formula

=Sum({<[Codice Documento]= {'CLI-SCONTRINO','NEG-FATIMM','FOR-DDTRESO','INT-BUONOSCA','SCA-DANN-FURTI'}>} [QTA 1 Documento])/sum (total({<[Codice Documento]= {'CLI-SCONTRINO','NEG-FATIMM','FOR-DDTRESO','INT-BUONOSCA','SCA-DANN-FURTI'}>} [QTA 1 Documento]))

I need to calculate the column percentage...how should it be written the formula? My problem is that this variable [Codice Documento] must respect those values {'CLI-SCONTRINO','NEG-FATIMM','FOR-DDTRESO','INT-BUONOSCA','SCA-DANN-FURTI'}....

thanks to everyone!

13 Replies
Not applicable
Author

swuehl thank you for your reply though...

Clever_Anjos
Employee
Employee

I was late, swuehl noticed the right spot.

Not applicable
Author

swuehl 's formula is working for me. The location of 'total' before/after set analysis doesn't affect the result. Check attachment for your info.

Not applicable
Author

you were right! I'm wondering why it wasn't working earlier when I copied and pasted the formula into my QV file...

Well thank you for the explanation I'm glad that the order of the set analysis doesn't affect the result!

a big thanks to all of you swuehl, Clever Anjos and @Yang LU