Qlik Community

Qlik Brasil

Group community for Brazil users. discussion only in Portuguese.

Highlighted
marcelvinicius
Contributor 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

Tags (1)
1 Solution

Accepted Solutions

Re: Percentual no Set Analysis

May be this

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

10 Replies

Re: Percentual no Set Analysis

May be this

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

marcelvinicius
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

marcelvinicius
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?qlik.png

Thank you again.

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)

marcelvinicius
Contributor III

Re: Percentual no Set Analysis

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

Do you can help me?

Att

Re: Percentual no Set Analysis

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

marcelvinicius
Contributor III

Re: Percentual no Set Analysis

when i choose one account:

qlik.png

after I choose, the calculation disappears

Re: Percentual no Set Analysis

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

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