Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

cromwelll
New Contributor

Group by dimension

I am having an issue with grouping certain departments in groups, and was wondering if anyone could help.

What I currently have is this:

=If(Match([Department], 'HR', 'HR-Development'), 'HR', If(Match([Department], 'Economy', 'Finance'), 'Economy'))

This works great and I could continue this on by infinity, but I have roughly 10 departments that I don't want to group by anything, and if I don't include them in the code they just get excluded from the Straight Table. This also causes an issue when new departments are created, since they won't show up.

My question is: Is there any way I can have the departments I exclude from the formula to simply show up under their original [Department] name?

Thanks in advance

1 Solution

Accepted Solutions
itsakshaye
New Contributor III

Re: Group by dimension

Try this

=If(Match([Department], 'HR', 'HR-Development'), 'HR', If(Match([Department], 'Economy', 'Finance'), 'Economy',[Department]))

2 Replies
itsakshaye
New Contributor III

Re: Group by dimension

Try this

=If(Match([Department], 'HR', 'HR-Development'), 'HR', If(Match([Department], 'Economy', 'Finance'), 'Economy',[Department]))

cromwelll
New Contributor

Re: Group by dimension

Works perfectly. Thank you