Discussion Board for collaboration related to Creating Analytics for QlikView.
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 !
Go to Solution.
You may use the following:
Sum(If(Index(Field2, Field1) > 0,costs,0))
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.