how to write expression

[#1]

Hi All,

I am new to qlik View.

I want write a expression for Field_Code.Which contains values=(12345,2344,344,78889,098090).My requirement is i want to exclude values starting with 1,2,3 and 4.How can i write it in qlik View Expression.Can any one suggest please.

[#2]

what kind of expression do you want? do you want to sum your Field_Code?

[rustyfishbones]

Do you need to do this in the Script?

[jonathandienst]

Hi

{<Field_Code -= {'1*', '2*', '3*', '4*'}>}

HTH

Jonathan

[rustyfishbones]

try something like

[tresesco]

Logic would be something like:

Sum( If( Not WildMatch(Field_Code, '1*', '2*', '3*', '4*') , Field_Code))

The same you can do with set analysis as well.

Edit: WildMatch

[#7]

No i dont want to sum.I only want exclude values starting with number 1,2,3,4

[#8]

then try only({<Field_Code -= {'1*', '2*', '3*', '4*'}>}Field_Code)

[amit_saini]

Hi Ipshita,

You can give a condition while calling that filed in the script like:

If(wildmatch(Field_Code, '1*', '2*', '3*', '4*',('','','',''))

Thanks,

[#10]

if(not wildmatch(fieldname,'1*','2*','3*','4*'),fieldname)