topic Expression and dimension in QlikView

Expression and dimension

Thu, 13 Jun 2013 16:24:08 GMT

Hello

i need to unify this dimension an expression in one expression....

calculated dimension:

=if((not wildmatch(DOCUMENTO,'*NDP*','*NCP*')<>0),DOCUMENTO)

expression:

sum(TREINTA)-sum({<ISSOTRX_Cartera={'N'},TIPO={'FC'}>}TREINTA)

how i could do this?

Tnks...

Re: Expression and dimension

Gysbert_Wassenaar — Thu, 13 Jun 2013 16:32:30 GMT

Your question doesn't make sense to me. You can make your sum expressions disregard records where DOCUMENTO contains the substrings NDP and NCP. If that's what you want try:

sum({<DOCUMENTO -= {'*NDP*','*NCP*'} >}TREINTA)-sum({<DOCUMENTO -= {'*NDP*','*NCP*'},ISSOTRX_Cartera={'N'},TIPO={'FC'}>}TREINTA)

Re: Expression and dimension

Thu, 13 Jun 2013 16:35:09 GMT

What are you trying to accomplish?

From your description I understand you want to show only the DOCUMENTS that doesn't match with '*NDP*' or '*NCP*'.

So... you could try this:

sum({<ISSOTRX_Cartera={'N'},TIPO={'FC'}, DOCUMENTO={'*'}-{'*NDP*','*NCP*'}>}TREINTA)