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

Grouping calculated dimensions

Hi, I have created two calculated dimensions called North Agents and South Agents like below.

North AgentsSouth Agents
David

Bob

StephenJane
AlexNancy
Jake

I want to create a new dimension called North South Agents including the North Agents and South Agents grouping. So the drill down would be like North South Agents -> North Agents & South Agents -> Bob, Jane, Nancy, Jake, David, Stephen, Alex.

Is there anyway I can do this? I would appreciate any answers. Front end calculated dimension is preferred but scripting is also very appreciated.

Thank you.

5 Replies
Not applicable
Author

Hi,

You have to create a table like this :

AgentGroupSubGroup
DavidNorth SouthNorth
StephenNorth SouthNorth
AlexNorth SouthNorth
BobNorth SouthSouth
JaneNorth SouthSouth
NancyNorth SouthSouth
JakeNorth SouthSouth

The script depends on your data model.

Regards;

Xavier.

Not applicable
Author

Hi Xavier, is there a way to do this on the front end using set analysis and conditional statements?

ramoncova06
Specialist III
Specialist III

you need to create a calculated dimension like this

if(Agent = 'David' or Agent = 'Stephen' or Agent = 'Alex', 'North', 'South')

Not applicable
Author

Thanks. It's a really tedious process because in the real data I have like 40 text values for conditions and in other datasets the number of conditions go up to +200. Thumb up but I'd appreciate it if there is an easier way to do this...

ramoncova06
Specialist III
Specialist III

you could always try with an applymap but that would be a backend script change, if you have another way to identify that is not at that granular level, you might be able to do a front end expression