Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
MuraliPrasath
Creator III
Creator III

Creating a Flag Field in Script.

Hi,

I need to create a 'Flag' field in Script to apply the same in Map Object.  Then following expression is used currently in the table to get the 'Flag', need this to be at script level. Is it possible?

=if(rangesum(above(total sum(Sales)/sum(Total Sales),0,RowNo(Total)))<=0.80, '1',
if( rangesum(above(total sum(Sales)/sum(Total Sales),0,RowNo(Total)))>=0.79, '0'))

I need this flag for my Map Area Layer Background color.

Labels (1)
0 Replies