topic Re: Return data with no primary key in QlikView https://community.qlik.com/t5/QlikView/Return-data-with-no-primary-key/m-p/379658#M141597 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>Do you need to eliminate those Values then use inner or left join </P></BODY></HTML> Wed, 22 Aug 2012 05:22:52 GMT sreenivas 2012-08-22T05:22:52Z Return data with no primary key https://community.qlik.com/t5/QlikView/Return-data-with-no-primary-key/m-p/379657#M141596 <HTML><HEAD></HEAD><BODY><P>i have an example here i just like to get the accounts with no ID but contains data.</P><P></P><P></P><P>table1</P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" height="116" style="border: 1px solid rgb(0, 0, 0); width: 607px;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle">AccountID</TH><TH align="center" style="background-color: #6690bc;" valign="middle">AccountName</TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Sales</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle">Month</TH></TR><TR><TD>101</TD><TD>James</TD><TD>100</TD><TD>Dec</TD></TR><TR><TD>102</TD><TD>Harden</TD><TD>250</TD><TD>Dec</TD></TR><TR><TD>-</TD><TD>-</TD><TD>350</TD><TD>Dec</TD></TR><TR><TD>104</TD><TD>Durant</TD><TD>200</TD><TD>Dec</TD></TR></TBODY></TABLE><P></P><P></P><P></P><P>What's the best way to show the blank data row.</P></BODY></HTML> Wed, 22 Aug 2012 01:55:10 GMT https://community.qlik.com/t5/QlikView/Return-data-with-no-primary-key/m-p/379657#M141596 2012-08-22T01:55:10Z Re: Return data with no primary key https://community.qlik.com/t5/QlikView/Return-data-with-no-primary-key/m-p/379658#M141597 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>Do you need to eliminate those Values then use inner or left join </P></BODY></HTML> Wed, 22 Aug 2012 05:22:52 GMT https://community.qlik.com/t5/QlikView/Return-data-with-no-primary-key/m-p/379658#M141597 sreenivas 2012-08-22T05:22:52Z Re: Return data with no primary key https://community.qlik.com/t5/QlikView/Return-data-with-no-primary-key/m-p/379659#M141598 <HTML><HEAD></HEAD><BODY><P>No sir, i just need to display the data without accountID.</P></BODY></HTML> Wed, 22 Aug 2012 06:25:01 GMT https://community.qlik.com/t5/QlikView/Return-data-with-no-primary-key/m-p/379659#M141598 2012-08-22T06:25:01Z Re: Return data with no primary key https://community.qlik.com/t5/QlikView/Return-data-with-no-primary-key/m-p/379660#M141599 <HTML><HEAD></HEAD><BODY><P>If it is a straight Table there will be a option Properties--&gt;dimensions Tab--&gt; check the <STRONG> Supress When Value is Null</STRONG> </P></BODY></HTML> Wed, 22 Aug 2012 06:28:29 GMT https://community.qlik.com/t5/QlikView/Return-data-with-no-primary-key/m-p/379660#M141599 sreenivas 2012-08-22T06:28:29Z Re: Return data with no primary key https://community.qlik.com/t5/QlikView/Return-data-with-no-primary-key/m-p/379661#M141600 <HTML><HEAD></HEAD><BODY><P>I need to display </P><P></P><P>- - 350 dec</P></BODY></HTML> Wed, 22 Aug 2012 06:45:18 GMT https://community.qlik.com/t5/QlikView/Return-data-with-no-primary-key/m-p/379661#M141600 2012-08-22T06:45:18Z Re: Return data with no primary key https://community.qlik.com/t5/QlikView/Return-data-with-no-primary-key/m-p/379662#M141601 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I'd use something like the following to exclude all fields that have a non blank / null value:</P><P></P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_text_macro jive_macro_code _jivemacro_uid_13466749846769047" jivemacro_uid="_13466749846769047"><P>Only({&lt; AccountID -= {"*"} &gt;} Sales)</P></PRE><P></P><P>or</P><P></P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_text_macro jive_macro_code _jivemacro_uid_13466750639154387" jivemacro_uid="_13466750639154387"><P>Only({1 - &lt; AccountID = P(AccountID) &gt;} Sales)</P></PRE><P></P><P>And the same set analysis with the Month field.</P><P></P><P>Hope that helps.</P><P></P><P>Miguel</P></BODY></HTML> Mon, 03 Sep 2012 12:25:02 GMT https://community.qlik.com/t5/QlikView/Return-data-with-no-primary-key/m-p/379662#M141601 Miguel_Angel_Baeyens 2012-09-03T12:25:02Z