Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set Analysis - Ignore a Group of Selections

Hi all

I have a table showing the capacity to carry out a number of surveys and the number of surveys planned.

All surveys are planned to a JobID and there are numerous dimensions for a JobID that the user can select.  However, survey capacity is just a projected number ie. Surveyor A can do 10 surveys in a day (they are not pre-assigned to a JobID).

SurveyorMetricTypeMondayTuesday
JohnCapacity1010
Planned78
Utilisation70%80%

When the user selects a JobID dimension I want the capacity to remain static.  I know how to do this using Set Analysis, but my question is whether you can group the JobID dimensions (for ease) instead of having to write the expression below

Sum({$<MetricType={Capacity}, Funding=, JobStatus=, JobType=>}FactValue)

The fields I have highlighted in red are the ones I would like to refer to as a single 'name', and then just add/remove fields from the 'name'

Thanks in advance

1 Solution

Accepted Solutions
marcus_sommer

To simplify your expression you could use a variable:

var = Funding=, JobStatus=, JobType=

Sum({$<MetricType={Capacity}, $(var) >}FactValue)

- Marcus

View solution in original post

2 Replies
marcus_sommer

To simplify your expression you could use a variable:

var = Funding=, JobStatus=, JobType=

Sum({$<MetricType={Capacity}, $(var) >}FactValue)

- Marcus

PrashantSangle

Hi,

Create Variable  in script

set vName= 'Funding=, JobStatus=, JobType='

Regards,

PS

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂