topic Crosstable in QlikView https://community.qlik.com/t5/QlikView/Crosstable/m-p/421453#M156973 <HTML><HEAD></HEAD><BODY><P>Hello All,</P><P></P><P>I need distinct values displayed in a crosstable. Here is my script-</P><P></P><P style="margin-bottom: 0.0001pt;"><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: blue;">CrossTable</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">(</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: maroon;">Acct#</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">, </SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: maroon;">Diagnosis</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">)<BR /> </SPAN><STRONG style="color: blue; font-size: 9.0pt; font-family: 'Courier New';">LOAD</STRONG> <SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: blue;">Distinct</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">&nbsp;&nbsp; <BR /> </SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: maroon;">[ENCTR ID]</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">,<BR /> </SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: maroon;">[PRIN DIAG]</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">,<BR /> </SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: maroon;">[SEC DIAG &amp; NAME]</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;"><BR /> </SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: blue;">Resident</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;"> 20112012; </SPAN></P><P></P><P style="margin-bottom: 0.0001pt;"><SPAN style="font-size: 10pt; font-family: 'Courier New'; color: black;">Here is whats displayed. If I just have 1 Prin Diag code for an acct it works fine and it only counts it once but thats not how it is displayed. I only want to see the record in red.</SPAN></P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 422px;"><TBODY><TR><TD height="20" width="86">ENCTR ID</TD><TD width="111">PRIN DIAG</TD><TD width="112">SEC DIAG</TD><TD width="113">All DIAG</TD></TR><TR><TD height="20">WHX0005000</TD><TD>250.80 DMIL OT…</TD><TD>584.6 END STAG..</TD><TD>789.00 ABDMNAL</TD></TR><TR><TD height="20">WHX0005001</TD><TD>250.80 DMIL OT…</TD><TD>783.1 NAUSEA</TD><TD>789.00 ABDMNAL</TD></TR><TR><TD height="20"><SPAN style="color: #993300;">WHX0005002</SPAN></TD><TD><SPAN style="color: #993300;">250.80 DMIL OT…</SPAN></TD><TD><SPAN style="color: #993300;">789.00 ABDMNAL</SPAN></TD><TD><SPAN style="color: #993300;">789.00 ABDMNAL</SPAN></TD></TR><TR><TD height="20">WHX0005003</TD><TD>250.80 DMIL OT…</TD><TD>790.8 ABN SERU…</TD><TD>789.00 ABDMNAL</TD></TR></TBODY></TABLE><P style="margin-bottom: 0.0001pt;"><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;"> </SPAN></P><P></P><P style="margin-bottom: 0.0001pt;"><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">Thanks for the help,</SPAN></P><P></P><P style="margin-bottom: 0.0001pt;"><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">EK<BR /></SPAN></P></BODY></HTML> Fri, 08 Feb 2013 20:28:43 GMT 2013-02-08T20:28:43Z Crosstable https://community.qlik.com/t5/QlikView/Crosstable/m-p/421453#M156973 <HTML><HEAD></HEAD><BODY><P>Hello All,</P><P></P><P>I need distinct values displayed in a crosstable. Here is my script-</P><P></P><P style="margin-bottom: 0.0001pt;"><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: blue;">CrossTable</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">(</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: maroon;">Acct#</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">, </SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: maroon;">Diagnosis</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">)<BR /> </SPAN><STRONG style="color: blue; font-size: 9.0pt; font-family: 'Courier New';">LOAD</STRONG> <SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: blue;">Distinct</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">&nbsp;&nbsp; <BR /> </SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: maroon;">[ENCTR ID]</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">,<BR /> </SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: maroon;">[PRIN DIAG]</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">,<BR /> </SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: maroon;">[SEC DIAG &amp; NAME]</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;"><BR /> </SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: blue;">Resident</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;"> 20112012; </SPAN></P><P></P><P style="margin-bottom: 0.0001pt;"><SPAN style="font-size: 10pt; font-family: 'Courier New'; color: black;">Here is whats displayed. If I just have 1 Prin Diag code for an acct it works fine and it only counts it once but thats not how it is displayed. I only want to see the record in red.</SPAN></P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 422px;"><TBODY><TR><TD height="20" width="86">ENCTR ID</TD><TD width="111">PRIN DIAG</TD><TD width="112">SEC DIAG</TD><TD width="113">All DIAG</TD></TR><TR><TD height="20">WHX0005000</TD><TD>250.80 DMIL OT…</TD><TD>584.6 END STAG..</TD><TD>789.00 ABDMNAL</TD></TR><TR><TD height="20">WHX0005001</TD><TD>250.80 DMIL OT…</TD><TD>783.1 NAUSEA</TD><TD>789.00 ABDMNAL</TD></TR><TR><TD height="20"><SPAN style="color: #993300;">WHX0005002</SPAN></TD><TD><SPAN style="color: #993300;">250.80 DMIL OT…</SPAN></TD><TD><SPAN style="color: #993300;">789.00 ABDMNAL</SPAN></TD><TD><SPAN style="color: #993300;">789.00 ABDMNAL</SPAN></TD></TR><TR><TD height="20">WHX0005003</TD><TD>250.80 DMIL OT…</TD><TD>790.8 ABN SERU…</TD><TD>789.00 ABDMNAL</TD></TR></TBODY></TABLE><P style="margin-bottom: 0.0001pt;"><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;"> </SPAN></P><P></P><P style="margin-bottom: 0.0001pt;"><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">Thanks for the help,</SPAN></P><P></P><P style="margin-bottom: 0.0001pt;"><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">EK<BR /></SPAN></P></BODY></HTML> Fri, 08 Feb 2013 20:28:43 GMT https://community.qlik.com/t5/QlikView/Crosstable/m-p/421453#M156973 2013-02-08T20:28:43Z