Filtering Dimensions in a PivotChart

[Julia_P]

Hi,

I inherited a Pivotchart that is really heavy when it comes to calculations because of expression.

The expressions are calculated as follows:

Business Unit =MaxString(Business_Unit_name), 
Sub Cost Center =MaxString(SF_FOCostCenter_name), 
Division= MaxString(SF_FODivision_name) etc.

I was asked to improve the performance and as a solution, I shifted all these expressions to dimensions but ended up with a breakdown as below (which was eliminated previously by using MaxString function). 

I tried to get rid of this breakdown using MaxString in calculated dimensions or by enabling conditional but unsuccessfully. 

Could someone explain why MaxString doesn't work here and advise another solution or improvement? 

Thank you!

[Brett_Bleess]

I have a couple of Help topics that may be of some use, but I am not sure:

https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/LoadData/best-p...

https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/application-per...

The other places you could look around would be the following, but not sure if there are any postings on this specific topic or not:

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

https://community.qlik.com/t5/QlikView-Documents/tkb-p/qlikview-documents

Specific Help on MaxString in charts:

https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/ChartFunctions/...

Hopefully that may get you somewhere.

Regards,
Brett