topic Re: or-connection in QlikView

or-connection

markus19-85 — Wed, 01 Jul 2015 11:30:38 GMT

Hi, I have the following problem.

I want to use an or-connection in my application.

If I select BMW and the colour blue, I get an amount of 10, but I would like to get the amount of all BMW and all cars with the colour blue.

Is this possible, maybe in script or as a function?

Thanks for support

MarcoWedel — Wed, 01 Jul 2015 16:18:45 GMT

=Sum({$<Colour=>+$<Car=>}Amount)

stigchel — Wed, 01 Jul 2015 16:19:59 GMT

You can use set analysis for that, for the above example

=sum({<Colour,Car=Car>+<Car,Colour=Colour>} Amount)

markus19-85 — Wed, 01 Jul 2015 16:41:58 GMT

sorry, but this is not working

Qrishna — Wed, 01 Jul 2015 16:54:59 GMT

For Code, See Attached.

stigchel — Wed, 01 Jul 2015 18:32:27 GMT

Your reply is not very helpfull in resolving this, what is not working?? Not at all, other value then expected? What value do you expect?

See attached, for me working, example

MarcoWedel — Wed, 01 Jul 2015 22:44:56 GMT

like this?

hope this helps

regards

Marco

markus19-85 — Fri, 03 Jul 2015 08:31:42 GMT

Yes, that's what i am looking for, thank you.

But does it also works with another field? for example, Sales_Person?

markus19-85 — Thu, 09 Jul 2015 06:56:38 GMT

any other solution, for more than two fields?