Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
matheus_silva
Creator
Creator

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
Specialist III
Specialist III

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

View solution in original post

4 Replies
manucamon
Specialist III
Specialist III

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

View solution in original post

matheus_silva
Creator
Creator
Author

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
Specialist III
Specialist III

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
Specialist III
Specialist III

Please, mark as correct to help other users.

Thanks!