topic I need to fix IF. Fixed Report in QlikView

I need to fix IF. Fixed Report

Ribeiro — Wed, 22 Nov 2017 11:45:09 GMT

I need product code 23927 to appear in the above chart.

I need to correct this set analysis. "Quantidade_IntesCOM)<>0"

if(sum({$<Ano ={$(=Year(today()))}, Mes={$(=Month(today()))},Dia={$(=Day(today()))},[CodigoFilial]={'1'},[Linha_Excluida]={'0'}>}Quantidade_IntesCOM)<>0,

sum({$<[Linha_Excluida]={'0'},[CodigoFilial]={'1'}>}Quantidade_IntesOTE))

The result I need is this. But this one with no fixed filter

Re: I need to fix IF. Fixed Report

ali_hijazi — Wed, 22 Nov 2017 12:02:32 GMT

check attached

is this what you want? !

if(sum(aggr(sum({$<Ano ={$(=Year(today()))}, Mes={$(=Month(today()))},[CodigoFilial]={'1'},[Linha_Excluida]={'0'}>}Quantidade_IntesCOM),CodigoProduto))<>0,

sum({$<[Linha_Excluida]={'0'},[CodigoFilial]={'1'}>}Quantidade_IntesOTE))

I removed the Dia={Day(Today())} cause your data shows fdata for 21 instead of 22

Re: I need to fix IF. Fixed Report

Ribeiro — Wed, 22 Nov 2017 12:24:57 GMT

Personal Edition,

You could tell how you solved it ... qvw no

Re: I need to fix IF. Fixed Report

ali_hijazi — Wed, 22 Nov 2017 13:11:50 GMT

I've written the expression above

you need to check if the sum is zero by product so I made the check to be sum(aggr(sum.....,CodigoProduto))