Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

greend21
Contributor II

Set Analysis to Ignore Selections

Can anyone figure out why this isn't working? Am I missing something obvious? I have a chart based off information on the CompletionTimes table. I added list boxes for QueueNameCT and ModuleCT. I want selections for QueueName and Module(from the AssignedWorkflows table) to be ignored. I have the below measure but any selections made in the QueueName or Module listboxes affect this chart. Any ideas?

Count({<Module=,QueueName=>}DISTINCT WorkflowID)

13 Replies

Re: Set Analysis to Ignore Selections

Would you be able to share a sample to test this out?

duncanblaine
Contributor

Re: Set Analysis to Ignore Selections

Try the following:
Count({<ModuleCT=,QueueNameCT=>}DISTINCT WorkflowID)


If you have list boxes for ModuleCT and QueueNameCT then they will be the selected fields you need to exclude in the Set Analysis.

Hope this helps

greend21
Contributor II

Re: Set Analysis to Ignore Selections

I want the chart to to filter when selections are made on ModuleCT or QueueNameCT. I don't want it to change when selections are made in Module or QueueName which are on other sheets.

greend21
Contributor II

Re: Set Analysis to Ignore Selections

Unfortunately I don't think I can. I put this in the below expression in another chart just to see if it would restrict QueueName selections and it worked as expected. I'm really not sure what is stopping it from working in the original scenario.

Count({<AssignedCompleted={Completed}, QueueName=>}WorkflowID)

Re: Set Analysis to Ignore Selections

Where are you using this? Can you post the images with and without selection to show the issue?

greend21
Contributor II

Re: Set Analysis to Ignore Selections

No selection

With Billing selected(from the list that I DON'T want to impact the chart).

Re: Set Analysis to Ignore Selections

Hahahahaha, so your expression is right... all you need to do is to ignore selection in your color expression ... What expression are you using for color?

greend21
Contributor II

Re: Set Analysis to Ignore Selections

Auto colors. I thought it shouldn't reflect any changes based on the selection?

Re: Set Analysis to Ignore Selections

Do you have a calculated dimension by any chance?

Community Browser