https://community.qlik.com/t5/App-Development/Creating-a-Flag-Field-in-Script/m-p/1685230#M52195 <P>Hi,</P><P>I need to create a 'Flag' field in Script to apply the same in Map Object.&nbsp; Then following expression is used currently in the table to get the 'Flag', need this to be at script level. Is it possible?</P><P>=if(rangesum(above(total sum(Sales)/sum(Total Sales),0,RowNo(Total)))&lt;=0.80, '1',<BR />if( rangesum(above(total sum(Sales)/sum(Total Sales),0,RowNo(Total)))&gt;=0.79, '0'))</P><P>I need this flag for my Map Area Layer Background color.</P> Sat, 16 Nov 2024 02:57:59 GMT MuraliPrasath 2024-11-16T02:57:59Z https://community.qlik.com/t5/App-Development/Creating-a-Flag-Field-in-Script/m-p/1685230#M52195 <P>Hi,</P><P>I need to create a 'Flag' field in Script to apply the same in Map Object.&nbsp; Then following expression is used currently in the table to get the 'Flag', need this to be at script level. Is it possible?</P><P>=if(rangesum(above(total sum(Sales)/sum(Total Sales),0,RowNo(Total)))&lt;=0.80, '1',<BR />if( rangesum(above(total sum(Sales)/sum(Total Sales),0,RowNo(Total)))&gt;=0.79, '0'))</P><P>I need this flag for my Map Area Layer Background color.</P> Sat, 16 Nov 2024 02:57:59 GMT https://community.qlik.com/t5/App-Development/Creating-a-Flag-Field-in-Script/m-p/1685230#M52195 MuraliPrasath 2024-11-16T02:57:59Z