topic Re: like in an expression in QlikView

like in an expression

Wed, 20 Feb 2013 20:30:44 GMT

hello

i have this expression:

(sum({$<ISPAIDDPNC={'N'}>}AMOUNTDDPNC)-sum({$<DESCRIPTION_Cruces_Linea={'* *'}>TOTALCXP_Cruces_Linea))

in the space i want a "like" where must be the id of the document of the row that is UM_NOTACREDITO_ID

how can i do this?

i want the sum of all totalCxPcruceslinea where the description like '%(multiples IDs)%'

thank's.

Re: like in an expression

Wed, 20 Feb 2013 20:42:40 GMT

Please clarify your question. If you need to filter based on substring you can use SubStringCount:

sum({$<DESCRIPTION_Cruces_Linea={"=SubStringCount(DESCRIPTION_Cruces_Linea, 'substr')"}>TOTALCXP_Cruces_Linea)

Re: like in an expression

Wed, 20 Feb 2013 20:51:35 GMT

ok,

example,

i have the field um_notacredito_Id with this values...1, 2, 3, 4, 5,........

i need the expression:

sum({$<DESCRIPTION_Cruces_Linea='*1*'}>TOTALCXP_Cruces_Linea),

sum({$<DESCRIPTION_Cruces_Linea='*2*'}>TOTALCXP_Cruces_Linea)

sum({$<DESCRIPTION_Cruces_Linea='*3*'}>TOTALCXP_Cruces_Linea)

sum({$<DESCRIPTION_Cruces_Linea='*4*'}>TOTALCXP_Cruces_Linea)

sum({$<DESCRIPTION_Cruces_Linea='*5*'}>TOTALCXP_Cruces_Linea)

for each row of the table chart that im trying to do.

Re: like in an expression

Wed, 20 Feb 2013 20:57:42 GMT

I still don't understand it. Where do you get these numbers -- 1, 2, 3, 4, 5? Do you have a field which contains them?

Re: like in an expression

alexandros17 — Wed, 20 Feb 2013 20:58:53 GMT

As you probably know, it is not possible to use a field in set analysis but you can use only values. Now,

If your field is UM_NOTACREDITO_ID then start (*) in set analysis works as like in queries so

sum({$<DESCRIPTION_Cruces_Linea={'*value of my field*'}>TOTALCXP_Cruces_Linea))

exctacts and sum all values that contains "value of my field". If you want you can use a selected value in a list box for instance using getfieldselected().

hope this may help