Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

matheus_silva
Contributor

Ignorando um Filtro (Ignore a filter)

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.

1 Solution

Accepted Solutions
manucamon
Valued Contributor III

Re: Ignorando um Filtro (Ignore a filter)

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!!!

4 Replies
manucamon
Valued Contributor III

Re: Ignorando um Filtro (Ignore a filter)

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!!!

matheus_silva
Contributor

Re: Ignorando um Filtro (Ignore a filter)

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

manucamon
Valued Contributor III

Re: Ignorando um Filtro (Ignore a filter)

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!

manucamon
Valued Contributor III

Re: Ignorando um Filtro (Ignore a filter)

Please, mark as correct to help other users.

Thanks!

Community Browser