topic Help in Expression in QlikView https://community.qlik.com/t5/QlikView/Help-in-Expression/m-p/1139693#M913605 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>How to find</P><P>Countrys with more then 2 shops are down.i have countrys and shop and down time</P><P>Thanks.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT 2020-11-25T16:16:04Z Help in Expression https://community.qlik.com/t5/QlikView/Help-in-Expression/m-p/1139693#M913605 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>How to find</P><P>Countrys with more then 2 shops are down.i have countrys and shop and down time</P><P>Thanks.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Help-in-Expression/m-p/1139693#M913605 2020-11-25T16:16:04Z Re: Help in Expression https://community.qlik.com/t5/QlikView/Help-in-Expression/m-p/1139694#M913606 <HTML><HEAD></HEAD><BODY><P>May be country as dimension and expression like this:</P><P></P><P><STRONG>If(Count(DISTINCT Shops) &gt; 1, </STRONG><SPAN style="font-size: 13.3333px;"><STRONG>Count(DISTINCT Shops))</STRONG></SPAN></P></BODY></HTML> Tue, 24 May 2016 20:12:33 GMT https://community.qlik.com/t5/QlikView/Help-in-Expression/m-p/1139694#M913606 sunny_talwar 2016-05-24T20:12:33Z