topic Re: Filtering Dimensions in a PivotChart in QlikView

Filtering Dimensions in a PivotChart

Julia_P — Sat, 16 Nov 2024 18:13:50 GMT

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!