Skip to main content
Announcements
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
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