Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Expression and dimension

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

1 Solution

Accepted Solutions
Not applicable
Author

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)

View solution in original post

2 Replies
Gysbert_Wassenaar

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)


talk is cheap, supply exceeds demand
Not applicable
Author

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)