Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Set Analysis - fix one selection, but not the other

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.

1 Solution

Accepted Solutions
MVP
MVP

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

You can disregard selections in Network using

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

2 Replies
datanibbler
Esteemed Contributor

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

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

MVP
MVP

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

You can disregard selections in Network using

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