topic Re: Set expression with multiple values in QlikView

Set expression with multiple values

stabben23 — Wed, 27 Feb 2013 07:19:49 GMT

I have problem to get sales when i have multiple %childs, what i want is when i select %Head i want to get all sales values from %Child. This works when i have a 1 to 1 relation between %Head and %child not when %childs are many.

This is about Items and need to know the sales from the Headitem and the childitems that belongs to the Headitem in the same Expression.

My expression: sum ({$<%Head = {"$(=%child)"}>}Sales)

Re: Set expression with multiple values

sushil353 — Wed, 27 Feb 2013 07:31:22 GMT

can u post the sample data

Re: Set expression with multiple values

stabben23 — Wed, 27 Feb 2013 07:59:31 GMT

Sushil, no Ii cant.

Re: Set expression with multiple values

lironbaram — Wed, 27 Feb 2013 08:06:03 GMT

may be you can try something like

sum({<%Heads={"$(=concat(%Child,',')"}>}Sales)

Re: Set expression with multiple values

stabben23 — Wed, 27 Feb 2013 08:28:13 GMT

Thanks liron, smal correction with no of Brackets and reduce of " then it works perfect!

sum({$<%Head={$(=concat(%child,','))}>}Sales)