topic Records Fetching in QlikView https://community.qlik.com/t5/QlikView/Records-Fetching/m-p/924459#M319975 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have a table like belo from that I want to retrieve only</P><P></P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); border-image: none; width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>ID1</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Name</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Place</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Phone</STRONG></TH></TR><TR><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD></TR><TR><TD style="padding: 2px;"><SPAN style="color: #33cccc;">1</SPAN></TD><TD style="padding: 2px;"><SPAN style="color: #33cccc;">A</SPAN></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"><SPAN style="color: #33cccc;">4587</SPAN></TD></TR><TR><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">C</TD><TD style="padding: 2px;">1245</TD></TR><TR><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">D</TD><TD style="padding: 2px;">1254</TD></TR><TR><TD style="padding: 2px;"><SPAN style="color: #3366ff;">2</SPAN></TD><TD style="padding: 2px;"><SPAN style="color: #3366ff;">B</SPAN></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"><SPAN style="color: #3366ff;">4567</SPAN></TD></TR><TR><TD style="padding: 2px;">2</TD><TD style="padding: 2px;">B</TD><TD style="padding: 2px;">E</TD><TD style="padding: 2px;">4585</TD></TR><TR><TD style="padding: 2px;">2</TD><TD style="padding: 2px;">B</TD><TD style="padding: 2px;">F</TD><TD style="padding: 2px;">4526</TD></TR></TBODY></TABLE><P></P><P>1,A,,4587</P><P>2,B,,4567</P><P></P><P>how to get those records.</P><P></P><P>Regards</P><P>John</P></BODY></HTML> Thu, 10 Sep 2015 11:04:17 GMT 2015-09-10T11:04:17Z Records Fetching https://community.qlik.com/t5/QlikView/Records-Fetching/m-p/924459#M319975 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have a table like belo from that I want to retrieve only</P><P></P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); border-image: none; width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>ID1</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Name</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Place</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Phone</STRONG></TH></TR><TR><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD></TR><TR><TD style="padding: 2px;"><SPAN style="color: #33cccc;">1</SPAN></TD><TD style="padding: 2px;"><SPAN style="color: #33cccc;">A</SPAN></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"><SPAN style="color: #33cccc;">4587</SPAN></TD></TR><TR><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">C</TD><TD style="padding: 2px;">1245</TD></TR><TR><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">D</TD><TD style="padding: 2px;">1254</TD></TR><TR><TD style="padding: 2px;"><SPAN style="color: #3366ff;">2</SPAN></TD><TD style="padding: 2px;"><SPAN style="color: #3366ff;">B</SPAN></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"><SPAN style="color: #3366ff;">4567</SPAN></TD></TR><TR><TD style="padding: 2px;">2</TD><TD style="padding: 2px;">B</TD><TD style="padding: 2px;">E</TD><TD style="padding: 2px;">4585</TD></TR><TR><TD style="padding: 2px;">2</TD><TD style="padding: 2px;">B</TD><TD style="padding: 2px;">F</TD><TD style="padding: 2px;">4526</TD></TR></TBODY></TABLE><P></P><P>1,A,,4587</P><P>2,B,,4567</P><P></P><P>how to get those records.</P><P></P><P>Regards</P><P>John</P></BODY></HTML> Thu, 10 Sep 2015 11:04:17 GMT https://community.qlik.com/t5/QlikView/Records-Fetching/m-p/924459#M319975 2015-09-10T11:04:17Z Re: Records Fetching https://community.qlik.com/t5/QlikView/Records-Fetching/m-p/924460#M319976 <HTML><HEAD></HEAD><BODY><P>Is the logic is to fetch those records where place is empty?</P></BODY></HTML> Thu, 10 Sep 2015 11:05:19 GMT https://community.qlik.com/t5/QlikView/Records-Fetching/m-p/924460#M319976 sunny_talwar 2015-09-10T11:05:19Z Re: Records Fetching https://community.qlik.com/t5/QlikView/Records-Fetching/m-p/924461#M319977 <HTML><HEAD></HEAD><BODY><P>This:</P><P></P><P><IMG __jive_id="98523" alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/98523_Capture.PNG" style="height: auto;" /></P><P></P><P>Uncheck '<STRONG>Suppress Zero-Values</STRONG>' on <STRONG>Presentation</STRONG> Tab</P><P></P><P>HTH</P><P></P><P>Best,</P><P>Sunny</P></BODY></HTML> Thu, 10 Sep 2015 11:09:50 GMT https://community.qlik.com/t5/QlikView/Records-Fetching/m-p/924461#M319977 sunny_talwar 2015-09-10T11:09:50Z