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: 
marcelvinicius
Creator III
Creator III

Percentual no Set Analysis

Bom dia comunidade

Seguinte, preciso criar uma tabela com valores percentuais, porém ao tentar usar um set analysis do valor que preciso, só busca valor para o valor correspondente (de faturamento);

Tenho o valor de objetivo através da medida: SUM(ValorObj) e preciso que todas as contas dividam pelo valor de Faturamento (Ordem = 1):

No exemplo abaixo a conta Lucro Bruto tem que ser 8%, Comissão Venda de Consorcio - 0,20%, e assim por diante.

valor.png

1 Solution

Accepted Solutions
sunny_talwar

May be this

Sum(ValorObj)/Sum(TOTAL {<Ordem = {'1'}>} ValorObj)

View solution in original post

10 Replies
sunny_talwar

May be this

Sum(ValorObj)/Sum(TOTAL {<Ordem = {'1'}>} ValorObj)

marcelvinicius
Creator III
Creator III
Author

Hi stalwar1‌ thanks ....

I Forgot to use TOTAL....

I need to make some adjustments, but I think this is right.

Thanks Again

marcelvinicius
Creator III
Creator III
Author

Good afternoon friend,

I am only in a situation, when selecting a certain account, the calculation disappears, how can I solve it?qlik.png

Thank you again.

sunny_talwar

Which field are you selecting in? Contas? May be try this

Sum(ValorObj)/Sum(TOTAL {<Ordem = {'1'}, Contas>} ValorObj)

or this

Sum(ValorObj)/Sum(TOTAL {1<Ordem = {'1'}>} ValorObj)

marcelvinicius
Creator III
Creator III
Author

I tried both ways, it did not work at all.

Do you can help me?

Att

sunny_talwar

Which field are you making selection in when you get this output?

marcelvinicius
Creator III
Creator III
Author

when i choose one account:

qlik.png

after I choose, the calculation disappears

sunny_talwar

When you say account, do you mean Contas, right?

marcelvinicius
Creator III
Creator III
Author

Thanks again for the friend help, with this formula you passed:

Sum (ValueObj) / Sum (TOTAL {<Order = {'1'}, Accounts>} ValueObj)

I got the account name in the script and solved it.

Thank you very much.