topic Re: Crosstable Expression in QlikView https://community.qlik.com/t5/QlikView/Crosstable-Expression/m-p/1440327#M432230 <HTML><HEAD></HEAD><BODY><P>I wish I could have thought of this... but is it just looking at the preceding row? What if it's not exactly in that order?</P></BODY></HTML> Tue, 22 Aug 2017 19:23:51 GMT cbaqir 2017-08-22T19:23:51Z Crosstable Expression https://community.qlik.com/t5/QlikView/Crosstable-Expression/m-p/1440324#M432227 <HTML><HEAD></HEAD><BODY><P>I have a crosstable where my requirement is to only show discrepancies (differences) in the chart. The duplicate can be on any of the dimensions after DESCRIPTION.</P><P></P><P>For example: since the ORDERABLE here is the same in both ECISA and CAREB for this DESCRIPTION, I would not want to show it on this chart:</P><P></P><P><IMG __jive_id="174120" alt="8-21-2017 1-31-07 PM.jpg" class="jive-image image-1" src="/legacyfs/online/174120_8-21-2017 1-31-07 PM.jpg" style="width: 620px; height: 303px;" /></P></BODY></HTML> Mon, 21 Aug 2017 20:34:58 GMT https://community.qlik.com/t5/QlikView/Crosstable-Expression/m-p/1440324#M432227 cbaqir 2017-08-21T20:34:58Z Re: Crosstable Expression https://community.qlik.com/t5/QlikView/Crosstable-Expression/m-p/1440325#M432228 <HTML><HEAD></HEAD><BODY><P>Look here?</P><P>Work around, May possible in script for 3rd expression then Use flag to exclude with in the Count statement</P></BODY></HTML> Tue, 22 Aug 2017 03:53:16 GMT https://community.qlik.com/t5/QlikView/Crosstable-Expression/m-p/1440325#M432228 Anil_Babu_Samineni 2017-08-22T03:53:16Z Re: Crosstable Expression https://community.qlik.com/t5/QlikView/Crosstable-Expression/m-p/1440326#M432229 <HTML><HEAD></HEAD><BODY><P>May be this</P><P></P><P><STRONG>If(Count(DOMAIN) = Before(Count(DOMAIN)) or Count(DOMAIN) = After(Count(DOMAIN)), Null(), Count(DOMAIN))</STRONG></P></BODY></HTML> Tue, 22 Aug 2017 12:14:45 GMT https://community.qlik.com/t5/QlikView/Crosstable-Expression/m-p/1440326#M432229 sunny_talwar 2017-08-22T12:14:45Z Re: Crosstable Expression https://community.qlik.com/t5/QlikView/Crosstable-Expression/m-p/1440327#M432230 <HTML><HEAD></HEAD><BODY><P>I wish I could have thought of this... but is it just looking at the preceding row? What if it's not exactly in that order?</P></BODY></HTML> Tue, 22 Aug 2017 19:23:51 GMT https://community.qlik.com/t5/QlikView/Crosstable-Expression/m-p/1440327#M432230 cbaqir 2017-08-22T19:23:51Z Re: Crosstable Expression https://community.qlik.com/t5/QlikView/Crosstable-Expression/m-p/1440328#M432231 <HTML><HEAD></HEAD><BODY><P>Not the preceding row... it is looking in preceding column and proceeding column</P></BODY></HTML> Tue, 22 Aug 2017 19:25:23 GMT https://community.qlik.com/t5/QlikView/Crosstable-Expression/m-p/1440328#M432231 sunny_talwar 2017-08-22T19:25:23Z Re: Crosstable Expression https://community.qlik.com/t5/QlikView/Crosstable-Expression/m-p/1440329#M432232 <HTML><HEAD></HEAD><BODY><P>Check out After/Before here:</P><P><A href="https://community.qlik.com/docs/DOC-8205">Missing Manual - Before() and After()</A></P></BODY></HTML> Tue, 22 Aug 2017 19:25:49 GMT https://community.qlik.com/t5/QlikView/Crosstable-Expression/m-p/1440329#M432232 sunny_talwar 2017-08-22T19:25:49Z