topic Create fag when two conditions are met in QlikView https://community.qlik.com/t5/QlikView/Create-fag-when-two-conditions-are-met/m-p/363257#M1177810 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>You have some misplaced parentheses. This should work:</P><P></P><P>IF(Count(Distinct First_Key) &lt;&gt; Count(Distinct Second_Key), 1, 0)</P><P></P><P>Regards</P><P>Jonathan</P></BODY></HTML> Wed, 21 Mar 2012 20:32:15 GMT jonathandienst 2012-03-21T20:32:15Z Create fag when two conditions are met https://community.qlik.com/t5/QlikView/Create-fag-when-two-conditions-are-met/m-p/363256#M1177809 <HTML><HEAD></HEAD><BODY><P>I would like to creat ea flag for when these two conditions are met:</P><P></P><P>IF(Count(Distinct(First_Key) &lt;&gt; Count(Distinct(Second_Key), 1, 0)))</P><P></P><P>but I don't quite get the syntax. Does this need to be a set analysis?</P><P></P><P>I just want to rerutn a 1 if the number of unque first_key is not the same as the number of unique second_key.</P></BODY></HTML> Wed, 21 Mar 2012 20:07:11 GMT https://community.qlik.com/t5/QlikView/Create-fag-when-two-conditions-are-met/m-p/363256#M1177809 Anonymous 2012-03-21T20:07:11Z Create fag when two conditions are met https://community.qlik.com/t5/QlikView/Create-fag-when-two-conditions-are-met/m-p/363257#M1177810 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>You have some misplaced parentheses. This should work:</P><P></P><P>IF(Count(Distinct First_Key) &lt;&gt; Count(Distinct Second_Key), 1, 0)</P><P></P><P>Regards</P><P>Jonathan</P></BODY></HTML> Wed, 21 Mar 2012 20:32:15 GMT https://community.qlik.com/t5/QlikView/Create-fag-when-two-conditions-are-met/m-p/363257#M1177810 jonathandienst 2012-03-21T20:32:15Z