topic Re: Expression : condition before a sum (condition avant de sommer) in QlikView

Expression : condition before a sum (condition avant de sommer)

Tue, 29 Jan 2013 00:19:17 GMT

Bonjour / Hello

I just started with Qlikview but i could not find out what i easily did with MS Access :

I want to sum a numeric field but only when a varchar field contains part of a text which is in another field.

This should be very simple..

Field 1 : murex

Field 2 : direct costs murex

Field 3 : costs (numeric field)

I want to make a sum only for the rows for which we find "murex" in "direct costs murex" (we exclude direct costs application XXYY)

A few try but that does not work :

If(Field 2 like '*Field 1*'; Sum (costs);0)

Thanks for your help !

Re: Expression : condition before a sum (condition avant de sommer)

nagaiank — Tue, 29 Jan 2013 01:04:05 GMT

You may use the following:

Sum(If(Index(Field2, Field1) > 0,costs,0))

Re: Expression : condition before a sum (condition avant de sommer)

Tue, 29 Jan 2013 09:11:34 GMT

Thanks a lot ! It works.

I did not see so many examples in the Qlikview reference manual for expressions. It is generic. If a valuable source exists for examples, do not hesitate to tell me.