topic Re: Flag in QlikView https://community.qlik.com/t5/QlikView/Flag/m-p/1217839#M866938 <HTML><HEAD></HEAD><BODY><P>Ok but what are those flags based on?</P><P>Why is it 1 or 0 or 2? What is the condition you want to use?</P><P>At some places 50 is having Flags 1,2 &amp; 0 for same Name.</P></BODY></HTML> Wed, 07 Dec 2016 16:05:59 GMT MK9885 2016-12-07T16:05:59Z Flag https://community.qlik.com/t5/QlikView/Flag/m-p/1217838#M866937 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have the below table as source.</P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>ID</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Name</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Available</TH></TR><TR><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">Aarthi</TD><TD style="padding: 2px;">0</TD></TR><TR><TD style="padding: 2px;">1</TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">Aarthi</SPAN></TD><TD style="padding: 2px;">0</TD></TR><TR><TD style="padding: 2px;">1</TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">Aarthi</SPAN></TD><TD style="padding: 2px;">50</TD></TR><TR><TD style="padding: 2px;">1</TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">Aarthi</SPAN></TD><TD style="padding: 2px;">50</TD></TR><TR><TD style="padding: 2px;">2</TD><TD style="padding: 2px;">Nikhil</TD><TD style="padding: 2px;">50</TD></TR><TR><TD style="padding: 2px;">2</TD><TD style="padding: 2px;">Nikhil</TD><TD style="padding: 2px;">0</TD></TR><TR><TD style="padding: 2px;">2</TD><TD style="padding: 2px;">Nikhil</TD><TD style="padding: 2px;">50</TD></TR><TR><TD style="padding: 2px;">3</TD><TD style="padding: 2px;">Yogesh</TD><TD style="padding: 2px;">0</TD></TR><TR><TD style="padding: 2px;">3</TD><TD style="padding: 2px;">Yogesh</TD><TD style="padding: 2px;">0</TD></TR></TBODY></TABLE><P></P><P>From the above sample data&nbsp; I want to generate the flag as below:</P><P></P><TABLE border="1" class="jiveBorder" style="border: 1px solid #000000; width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>ID</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Name</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Available</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Flag</TH></TR><TR><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">Aarthi</TD><TD style="padding: 2px;">0</TD><TD style="padding: 2px;">1</TD></TR><TR><TD style="padding: 2px;">1</TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">Aarthi</SPAN></TD><TD style="padding: 2px;">0</TD><TD style="padding: 2px;">1</TD></TR><TR><TD style="padding: 2px;">1</TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">Aarthi</SPAN></TD><TD style="padding: 2px;">50</TD><TD style="padding: 2px;">0</TD></TR><TR><TD style="padding: 2px;">1</TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">Aarthi</SPAN></TD><TD style="padding: 2px;">50</TD><TD style="padding: 2px;">0</TD></TR><TR><TD style="padding: 2px;">2</TD><TD style="padding: 2px;">Nikhil</TD><TD style="padding: 2px;">50</TD><TD style="padding: 2px;">1</TD></TR><TR><TD style="padding: 2px;">2</TD><TD style="padding: 2px;">Nikhil</TD><TD style="padding: 2px;">0</TD><TD style="padding: 2px;">0</TD></TR><TR><TD style="padding: 2px;">2</TD><TD style="padding: 2px;">Nikhil</TD><TD style="padding: 2px;">50</TD><TD style="padding: 2px;">2</TD></TR><TR><TD style="padding: 2px;">3</TD><TD style="padding: 2px;">Yogesh</TD><TD style="padding: 2px;">0</TD><TD style="padding: 2px;">1</TD></TR><TR><TD style="padding: 2px;">3</TD><TD style="padding: 2px;">Yogesh</TD><TD style="padding: 2px;">0</TD><TD style="padding: 2px;">1</TD></TR></TBODY></TABLE><P></P><P>Please help me out to generate the above flag.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Flag/m-p/1217838#M866937 Anonymous 2020-11-25T16:16:04Z Re: Flag https://community.qlik.com/t5/QlikView/Flag/m-p/1217839#M866938 <HTML><HEAD></HEAD><BODY><P>Ok but what are those flags based on?</P><P>Why is it 1 or 0 or 2? What is the condition you want to use?</P><P>At some places 50 is having Flags 1,2 &amp; 0 for same Name.</P></BODY></HTML> Wed, 07 Dec 2016 16:05:59 GMT https://community.qlik.com/t5/QlikView/Flag/m-p/1217839#M866938 MK9885 2016-12-07T16:05:59Z Re: Flag https://community.qlik.com/t5/QlikView/Flag/m-p/1217840#M866939 <HTML><HEAD></HEAD><BODY><P>Can you share the logic as to how you are doing this?</P></BODY></HTML> Wed, 07 Dec 2016 16:11:47 GMT https://community.qlik.com/t5/QlikView/Flag/m-p/1217840#M866939 sunny_talwar 2016-12-07T16:11:47Z