topic Help with expression in QlikView

Help with expression

hopkinsc — Mon, 02 Apr 2012 14:50:53 GMT

Hi everyone,

Can you tell me if the following expression is correct please?

sum(if(wildmatch(Narrative,'STKADJ*'>0 or Narrative,'GRN*')>0,StockValue))

I need it to give me a figure of the StockValue for anything where the Narrative is wildmatched to STKADJ and GRN.

Thanks

CELAMBARASAN — Mon, 02 Apr 2012 14:58:51 GMT

Hi,

Change it to

sum(if(wildmatch(Narrative,'STKADJ*') or wildMatch( Narrative,'GRN*'),Sum(StockValue)))

Celambarasan

swuehl — Mon, 02 Apr 2012 15:02:31 GMT

If I understood correctly:

=sum(if(wildmatch(Narrative,'STKADJ*','GRN*')>0,StockValue))

hopkinsc — Mon, 02 Apr 2012 15:05:19 GMT

Thanks for that. It didn't quite work but i changed it to

sum(if(wildmatch(Narrative,'STKADJ*') or wildMatch( Narrative,'GRN*'),StockValue))

Which worked.

Thanks

Hi Stefan,

Thanks that also worked and is easier to understand.

Thanks