This content has been marked as final. Show 2 replies
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 !