# Qlik Brasil

Group community for Brazil users. discussion only in Portuguese.

Highlighted
Contributor III

## Percentual no Set Analysis

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.

Tags (1)
1 Solution

Accepted Solutions
MVP

## Re: Percentual no Set Analysis

May be this

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

10 Replies
MVP

## Re: Percentual no Set Analysis

May be this

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

Contributor III

## Re: Percentual no Set Analysis

Hi stalwar1‌ thanks ....

I Forgot to use TOTAL....

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

Thanks Again

Contributor III

## Re: Percentual no Set Analysis

Good afternoon friend,

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

Thank you again.

MVP

## Re: Percentual no Set Analysis

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)

Contributor III

## Re: Percentual no Set Analysis

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

Do you can help me?

Att

MVP

## Re: Percentual no Set Analysis

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

Contributor III

## Re: Percentual no Set Analysis

when i choose one account:

after I choose, the calculation disappears

MVP

## Re: Percentual no Set Analysis

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

Contributor III

## Re: Percentual no Set Analysis

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.