https://community.qlik.com/t5/App-Development/Format-range-of-values-in-the-scale/m-p/1628462#M46752 Hi everyone, I would like to understand how I can change a scale value of a chart only in a certain filter, thi : =if([field]='value of field', num(sum(Value)/sum(total Value), '#,##0%')) have you suggest? thx, Billy Thu, 26 Sep 2019 08:35:51 GMT Billy_u 2019-09-26T08:35:51Z https://community.qlik.com/t5/App-Development/Format-range-of-values-in-the-scale/m-p/1628462#M46752 Hi everyone, I would like to understand how I can change a scale value of a chart only in a certain filter, thi : =if([field]='value of field', num(sum(Value)/sum(total Value), '#,##0%')) have you suggest? thx, Billy Thu, 26 Sep 2019 08:35:51 GMT https://community.qlik.com/t5/App-Development/Format-range-of-values-in-the-scale/m-p/1628462#M46752 Billy_u 2019-09-26T08:35:51Z https://community.qlik.com/t5/App-Development/Format-range-of-values-in-the-scale/m-p/1628468#M46753 <P>Hi Billy,</P><P>You can Get the selected filter value by GetFieldSelections function and then you can compare that with you field ,&nbsp;</P><P>Like i<SPAN>f([field]=GetFieldSelection(Field), num(sum(Value)/sum(total Value), '#,##0%'))</SPAN></P><P>&nbsp;</P><P><SPAN><A href="https://help.qlik.com/en-US/sense/June2019/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/FieldFunctions/getfieldselections.htm" target="_blank">https://help.qlik.com/en-US/sense/June2019/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/FieldFunctions/getfieldselections.htm</A></SPAN></P><P>&nbsp;</P><P>&nbsp;</P> Thu, 26 Sep 2019 08:55:03 GMT https://community.qlik.com/t5/App-Development/Format-range-of-values-in-the-scale/m-p/1628468#M46753 sagarjagga 2019-09-26T08:55:03Z https://community.qlik.com/t5/App-Development/Format-range-of-values-in-the-scale/m-p/1628497#M46757 I change the value of the scale as a percentage, but it also changes it for the other measurements in the filter object =if ([field] = GetFieldSelections ('value field'), num (sum (Value), '0%')) Thu, 26 Sep 2019 09:51:14 GMT https://community.qlik.com/t5/App-Development/Format-range-of-values-in-the-scale/m-p/1628497#M46757 Billy_u 2019-09-26T09:51:14Z