Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Attend QlikWorld 2020 and hear keynote speaker, Malcolm Gladwell. Register by February 29th to save $200. Learn More
Highlighted
alisonpwallis
Contributor

Set analysis or aggr?

Hi

I have a gauge which I want to show for a subset of my data defined by selecting certain values from two particular fields. I am using set analysis for the first subset which enables me to select data where a particular condition is met but I can't work out how to select the second subset.

So: I have a target for numbers of students which is dependent on where they come from - either the EU or outside the EU. I want a gauge for each target. I want the pointer to show for that gauge (i.e. for those from the EU only) the numbers with an appropriate status (i.e. that they have applied and been accepted). So I have this initially:

=sum({$ <[Application Status]={"U/F","C/F"}>}  [FTE])

where Application Statuses of U/F and C/F mean the students have accepted their offers. So I need to include somewhere in this statement the Location field which would be [Residency Desc]='EU' for the EU target (for example)  otherwise I get the same value for both gauges.

Can I do this by nesting the set analysis? Or can I use aggr? Because I want to set conditions on both fields I am having trouble!

Any help would be very much appreciated!


Thanks

Alison

Tags (2)
1 Solution

Accepted Solutions
Highlighted
Partner
Partner

Re: Set analysis or aggr?

If I understand you correctly you also want to add a filter that only targets EU?  Try this:

sum({$ <[Application Status]={"U/F","C/F"}, [Residency Desc]={'EU'}>}  [FTE])

View solution in original post

4 Replies
Highlighted
MVP
MVP

Re: Set analysis or aggr?

You can use like ..

FOR EU

=sum({$ <[Application Status]={"U/F","C/F"},[Residency Desc]={'EU'} >}  [FTE])


and


FOR NON EU

=sum({$ <[Application Status]={"U/F","C/F"},[Residency Desc]-={'EU'} >}  [FTE])

Highlighted
Partner
Partner

Re: Set analysis or aggr?

If I understand you correctly you also want to add a filter that only targets EU?  Try this:

sum({$ <[Application Status]={"U/F","C/F"}, [Residency Desc]={'EU'}>}  [FTE])

View solution in original post

Highlighted
Not applicable

Re: Set analysis or aggr?

Please try something like...

=sum({$ <[Application Status]={'U/F','C/F'}, { [Residency Desc]={'EU'}} >}  [FTE])

Highlighted
alisonpwallis
Contributor

Re: Set analysis or aggr?

Thank you everyone - it works