topic Re: Ignorando um Filtro (Ignore a filter) in QlikView

Ignorando um Filtro (Ignore a filter)

Anonymous — Wed, 22 Jun 2016 20:51:32 GMT

Good Evenign.

Guys, my english is not very good, but i'll try.

I'm with situation again, a agregation situation. Now i have to sum all sales by providor when i filter by code provider bond, monthly.

I using a expression:

sum(total {1} sales)

It work, for year, but when i filter the month, sample(year=2016 and month=Jan), the values not modify, i think because this {1}.

Actually i wanna filter the month and qlikview sum all sales values by provider and give me a total, same filtering a single provider, because a have to make a percent (sales by provider/total sales) ,for know the participation each provider in my sales.

Sorry my english, but this is very important to me.

I will write in Portuguese too.

Thanks.

Boa noite.

Eu estou com uma situação novamente, uma de agregação. Agoraeu tenho que somar todas as vendas por fornecedor quando eu filtro por código de vinculo de fornecedor, mensalmente.

Eu usei isso:

sum(total {1} sales)

Funcionou por ano, mas quando eu filto mês, exemplo(ano=2016 mes=jan), o valor não modifica, eu acho que por causa do {1}.

Na verdade, eu quero filtrar o mes e o qulikview somar todas as venda por fornecedor e me dar um total, mesmo filtando um unico fornecedor, porque eu tenho que fazer um pencetual(venda por fornecedor/venda total), para saber um percentual de participação do fornecedor na minha venda.

Obrigado.

Re: Ignorando um Filtro (Ignore a filter)

Anonymous — Thu, 23 Jun 2016 07:02:18 GMT

HI Matheus,

If you wanna sum ignoring year:

Sum(Total {<Year=>} sales)

If you wanna ignore all selections, but don't ignore Month:

Sum(TOTAL {1<Month = P({$} Month) >} Sales)

Regards!!!

Re: Ignorando um Filtro (Ignore a filter)

Anonymous — Thu, 23 Jun 2016 11:47:25 GMT

Thank you so much Manuel...

it worked very well...

If i understand correctly, this "{1<Month = P({$} Month)>}" is to sum all values, less the month, because this "P", correct?...I learned something new now, but i have a lot to learn yet....

Anyway, it worked...thank you again...

Re: Ignorando um Filtro (Ignore a filter)

Anonymous — Thu, 23 Jun 2016 12:34:24 GMT

Hi Matheus,

With 1 you ignore all selections, because you are considering all set of your fields.

With Month = P({$} Month) you modify the set {1}. This expression says that include months on current selections of Month Field.

Regards!

Re: Ignorando um Filtro (Ignore a filter)

Anonymous — Thu, 23 Jun 2016 12:34:56 GMT

Please, mark as correct to help other users.

Thanks!