topic Cross Table Show where one occurence in QlikView https://community.qlik.com/t5/QlikView/Cross-Table-Show-where-one-occurence/m-p/1374442#M419677 <HTML><HEAD></HEAD><BODY><P>Right now, my chart based on the cross table shows every ORDER_VV where the dimensions are the same. I want to ONLY show items where there is only one occurrence at 1 ORDER_VV.</P><P></P><P>For example: The only item in this DESCRIPTION that only occurs at 1 ORDER_VV is the following so I would ONLY want to see it and the ORDER_VV of SMLB.</P><P></P><P>Something with conditional using getselectedcount maybe?</P><P></P><P><IMG alt="8-23-2017 2-38-38 PM.jpg" class="jive-image image-1" src="/legacyfs/online/174459_8-23-2017 2-38-38 PM.jpg" style="width: 702px; height: 110px;" /></P><P></P><P>TIA!</P></BODY></HTML> Wed, 23 Aug 2017 21:50:16 GMT cbaqir 2017-08-23T21:50:16Z Cross Table Show where one occurence https://community.qlik.com/t5/QlikView/Cross-Table-Show-where-one-occurence/m-p/1374442#M419677 <HTML><HEAD></HEAD><BODY><P>Right now, my chart based on the cross table shows every ORDER_VV where the dimensions are the same. I want to ONLY show items where there is only one occurrence at 1 ORDER_VV.</P><P></P><P>For example: The only item in this DESCRIPTION that only occurs at 1 ORDER_VV is the following so I would ONLY want to see it and the ORDER_VV of SMLB.</P><P></P><P>Something with conditional using getselectedcount maybe?</P><P></P><P><IMG alt="8-23-2017 2-38-38 PM.jpg" class="jive-image image-1" src="/legacyfs/online/174459_8-23-2017 2-38-38 PM.jpg" style="width: 702px; height: 110px;" /></P><P></P><P>TIA!</P></BODY></HTML> Wed, 23 Aug 2017 21:50:16 GMT https://community.qlik.com/t5/QlikView/Cross-Table-Show-where-one-occurence/m-p/1374442#M419677 cbaqir 2017-08-23T21:50:16Z Re: Cross Table Show where one occurence https://community.qlik.com/t5/QlikView/Cross-Table-Show-where-one-occurence/m-p/1374443#M419678 <HTML><HEAD></HEAD><BODY><P>May be this</P><P></P><P><STRONG>If(Count(TOTAL &lt;DESCRIPTION, NOTE, ORDERABLE, ORDER_SENTENCE, PRECHECKED, DOMAIN&gt; ORDER_VV) = 1, Count(ORDER_VV))</STRONG></P></BODY></HTML> Thu, 24 Aug 2017 08:51:52 GMT https://community.qlik.com/t5/QlikView/Cross-Table-Show-where-one-occurence/m-p/1374443#M419678 sunny_talwar 2017-08-24T08:51:52Z Re: Cross Table Show where one occurence https://community.qlik.com/t5/QlikView/Cross-Table-Show-where-one-occurence/m-p/1374444#M419679 <HTML><HEAD></HEAD><BODY><P>Thank you!</P></BODY></HTML> Thu, 24 Aug 2017 15:06:33 GMT https://community.qlik.com/t5/QlikView/Cross-Table-Show-where-one-occurence/m-p/1374444#M419679 cbaqir 2017-08-24T15:06:33Z