topic Set Analysis Count Where Instance is &gt;1 in QlikView https://community.qlik.com/t5/QlikView/Set-Analysis-Count-Where-Instance-is-gt-1/m-p/971697#M332603 <HTML><HEAD></HEAD><BODY><P>I'm working on an expression/measure to count the number of reservations with Air AND <SPAN style="text-decoration: underline;">either</SPAN> Car <SPAN style="text-decoration: underline;">or</SPAN> Hotel. See attached data set example. I'm using Column E as the identifier as it will be same for the reservation elements (Air, Car, Hotel). I need to count those that have both Air and Car or Hotel. As a reference I'm using the following to count Air transactions:</P><P>Count(Distinct{$&lt;[Booking Type] = {'Air'}, [Transaction Type] = {'Sale'}&gt;} [Record Locator])</P><P></P><P>I tried to single out Car/Hotel <SPAN style="text-decoration: underline;">without</SPAN> Air using the following but it did not work:</P><P>Count(Distinct{&lt;[Record Locator] = {'&gt;1'}, [Booking Sub Type] += {'Car','Hotel'}, [Booking Type] -= {'Air'}, [Transaction Type] = {'Sale'}&gt;} [Record Locator])</P><P></P><P>Any suggestions would be greatly appreciated. Thanks!</P></BODY></HTML> Wed, 30 Sep 2015 14:45:38 GMT jcampbell 2015-09-30T14:45:38Z Set Analysis Count Where Instance is >1 https://community.qlik.com/t5/QlikView/Set-Analysis-Count-Where-Instance-is-gt-1/m-p/971697#M332603 <HTML><HEAD></HEAD><BODY><P>I'm working on an expression/measure to count the number of reservations with Air AND <SPAN style="text-decoration: underline;">either</SPAN> Car <SPAN style="text-decoration: underline;">or</SPAN> Hotel. See attached data set example. I'm using Column E as the identifier as it will be same for the reservation elements (Air, Car, Hotel). I need to count those that have both Air and Car or Hotel. As a reference I'm using the following to count Air transactions:</P><P>Count(Distinct{$&lt;[Booking Type] = {'Air'}, [Transaction Type] = {'Sale'}&gt;} [Record Locator])</P><P></P><P>I tried to single out Car/Hotel <SPAN style="text-decoration: underline;">without</SPAN> Air using the following but it did not work:</P><P>Count(Distinct{&lt;[Record Locator] = {'&gt;1'}, [Booking Sub Type] += {'Car','Hotel'}, [Booking Type] -= {'Air'}, [Transaction Type] = {'Sale'}&gt;} [Record Locator])</P><P></P><P>Any suggestions would be greatly appreciated. Thanks!</P></BODY></HTML> Wed, 30 Sep 2015 14:45:38 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-Count-Where-Instance-is-gt-1/m-p/971697#M332603 jcampbell 2015-09-30T14:45:38Z