I was wondering if I could aggregate somehow, possibly with an expression, the data I'm looking at for my filter pane.
For example, my data set looks like the following:
Client A
Client A Inc
Client A
Client A
Client A Inc.
Client A Incorporated
Client A Services
For my dashboard I am using a filter pane by Client but as you can see it may be called something slightly different so all of these options would show up in my filter pane. In order to see them all, I would have to click individually on all the variances.
So my question is, is there some sort of expression I can use in Qlik Sense to do this? Or is the best option to save my data?
