Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Billy_u
New Contributor III

Format range of values ​​in the scale

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
2 Replies
sagarjagga
Contributor

Re: Format range of values ​​in the scale

Hi Billy,

You can Get the selected filter value by GetFieldSelections function and then you can compare that with you field , 

Like if([field]=GetFieldSelection(Field), num(sum(Value)/sum(total Value), '#,##0%'))

 

https://help.qlik.com/en-US/sense/June2019/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/FieldFunc...

 

 

Billy_u
New Contributor III

Re: Format range of values ​​in the scale

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%'))