topic Re: EXPRESSION and FILTER PROBLEM in QlikView

EXPRESSION and FILTER PROBLEM

Wed, 16 Oct 2013 13:13:07 GMT

Hi Everyone !
My and my partner have a very urgent problem.

We have the next expression:

=if(Count(distinct MARCA = 1,

if(sum(Techo) > 0 and sum(Piso) = 0,

count({$<Cliente.NODO = {"=(sum({<Cliente.Nodo>} Compro_CAJAS) / sum({<Cliente.Nodo>} Techo) ) < 1"} > } Techo)

,'-')

With some dimensions:
MES, LIQUIDACION...

If we do FILTER data for any field of the PRODUCTOS table, like MARCA p.e. the expression works great,
But if we do not use filters the expression does not work !!!!

Any idea??

We will be unemployed soon if we do not solve this problem !!!!

Thanks in advance to everyone !!!

Re: EXPRESSION and FILTER PROBLEM

Gysbert_Wassenaar — Wed, 16 Oct 2013 16:02:15 GMT

It's amazing it works at all. There are at least two syntax errors in that expression. The parentheses don't match up. Can you post an example document that demonstrates the problem? Read this document: Preparing examples for Upload - Reduction and Data Scrambling

Re: Re: EXPRESSION and FILTER PROBLEM

Wed, 16 Oct 2013 19:22:36 GMT

My falt, I mis the last parentheses..
I am attaching an example with only one expression. This expression has several parts that are all the same, so I coment them to make it easier.

Note that the expresion result is different if you filter by Cod_Accion for example, than if you do not filter. The result I need is the one with the filter.

Re: EXPRESSION and FILTER PROBLEM

Wed, 16 Oct 2013 20:53:01 GMT

The problem is set analysis. When he took the selection works. You have to review the syntax.

Re: EXPRESSION and FILTER PROBLEM

Wed, 16 Oct 2013 21:17:20 GMT

I am sorry Giancarlo, what do you want to mean?

Sintax here? editor understand and does not say there is an error on it.

count({$<Cliente.NODO = {"=(sum({<Cliente.Nodo>} Compro_CAJAS) / sum({<Cliente.Nodo>} Techo) ) < 1"} > } Techo)