topic Re: Set Analysis - fix one selection, but not the other in QlikView

Set Analysis - fix one selection, but not the other

Wed, 18 Dec 2013 11:04:46 GMT

Hi there -

Here's what I'm trying to do. I have two list boxes, Networks and HH (household). I'd like the outcome, Total Time Spent, updated when users select different HHs, but not Networks.

To fix HH, i need to add 1 to the set analysis, but how do I include the two sets in one formula? I've attached a file.

Re: Set Analysis - fix one selection, but not the other

datanibbler — Wed, 18 Dec 2013 11:08:36 GMT

Hi Carol,

try with the set-operator >P< - roughly like this

{1<field1 = P(field1)>}

That way, you disregard all user selections, optionally you can specify some fixed selections and those with the 'P' you leave to the user.

HTH

Best regards,

DataNibbler

Re: Set Analysis - fix one selection, but not the other

swuehl — Wed, 18 Dec 2013 11:08:48 GMT

You can disregard selections in Network using

Sum ( {<Network=>} [Time spent])