topic How to implement trieif in this case in QlikView https://community.qlik.com/t5/QlikView/How-to-implement-trieif-in-this-case/m-p/242972#M1195502 <HTML><HEAD></HEAD><BODY><P> Dear Friends,</P><P></P><PRE>i have one column named ITEM having values 10,20,30,..<BR />Help me to write expression in chart which will tell me<BR />trieif values are not repeated and false if values are repeated..example..<BR />If ITEM contains 10,20,20,30 on selection....so inthis case it would be false as 20 is repeating..</PRE><P></P><P></P><P></P><P> Thanks in advance friends</P></BODY></HTML> Wed, 29 Jun 2011 15:35:37 GMT 2011-06-29T15:35:37Z How to implement trieif in this case https://community.qlik.com/t5/QlikView/How-to-implement-trieif-in-this-case/m-p/242972#M1195502 <HTML><HEAD></HEAD><BODY><P> Dear Friends,</P><P></P><PRE>i have one column named ITEM having values 10,20,30,..<BR />Help me to write expression in chart which will tell me<BR />trieif values are not repeated and false if values are repeated..example..<BR />If ITEM contains 10,20,20,30 on selection....so inthis case it would be false as 20 is repeating..</PRE><P></P><P></P><P></P><P> Thanks in advance friends</P></BODY></HTML> Wed, 29 Jun 2011 15:35:37 GMT https://community.qlik.com/t5/QlikView/How-to-implement-trieif-in-this-case/m-p/242972#M1195502 2011-06-29T15:35:37Z How to implement trieif in this case https://community.qlik.com/t5/QlikView/How-to-implement-trieif-in-this-case/m-p/242973#M1195503 <HTML><HEAD></HEAD><BODY><P>Hi Kamalnaithani,</P><P></P><P>you could compare count (ITEM) with count(distinct ITEM) to get what you want, I think.</P><P></P><P>if(count(ITEM) &gt; count(distinct ITEM), 'false', 'true')</P><P></P><P>Regards,</P><P>Stefan</P></BODY></HTML> Wed, 29 Jun 2011 16:28:19 GMT https://community.qlik.com/t5/QlikView/How-to-implement-trieif-in-this-case/m-p/242973#M1195503 swuehl 2011-06-29T16:28:19Z