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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
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