topic Re: how to write expression in QlikView

how to write expression

Mon, 27 Jan 2014 11:03:21 GMT

Hi All,

I am new to qlik View.

Mon, 27 Jan 2014 11:08:58 GMT

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

rustyfishbones — Mon, 27 Jan 2014 11:09:11 GMT

Do you need to do this in the Script?

jonathandienst — Mon, 27 Jan 2014 11:10:09 GMT

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

HTH

Jonathan

rustyfishbones — Mon, 27 Jan 2014 11:10:37 GMT

try something like

tresB — Mon, 27 Jan 2014 11:11:36 GMT

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

Mon, 27 Jan 2014 11:14:03 GMT

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

Mon, 27 Jan 2014 11:15:12 GMT

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

amit_saini — Mon, 27 Jan 2014 11:18:11 GMT

Hi Ipshita,

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

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

Thanks,

Mon, 27 Jan 2014 11:20:01 GMT

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