topic Re: Querying Data from within a file in QlikView https://community.qlik.com/t5/QlikView/Querying-Data-from-within-a-file/m-p/1139110#M635079 <HTML><HEAD></HEAD><BODY><P>Hi!!</P><P>Thanks for the reply... Do you know if there's any way I can open the file??</P><P>It says that it has been opened too many times or something... and I can't open it on my personal license nor on the one I have on a server...</P></BODY></HTML> Wed, 25 May 2016 13:35:15 GMT 2016-05-25T13:35:15Z Querying Data from within a file https://community.qlik.com/t5/QlikView/Querying-Data-from-within-a-file/m-p/1139108#M635077 <HTML><HEAD></HEAD><BODY><P>Dear Qlik Community! </P><P>I've tried to solve this forever... but can't get it right yet. </P><P>What i'm trying to do is to get all the facebook comments for facebook posts, but there are two different queries from the QV Source App...</P><P></P><P>So that means I need to:</P><P>Query A: Get all the ID's for the posts</P><P>Query B: Get all the comments from the Posts on Query A</P><P>Join Query B's results into Query A, linking the comments to the post ID's from Query A.</P><P></P><P>Can anybody help me out? Should I export the comments to a separate file, query the file row by row, then join the answers??</P><P>I really have no idea how to do this...</P><P></P><P>Thanks!</P></BODY></HTML> Tue, 24 May 2016 20:06:16 GMT https://community.qlik.com/t5/QlikView/Querying-Data-from-within-a-file/m-p/1139108#M635077 2016-05-24T20:06:16Z Re: Querying Data from within a file https://community.qlik.com/t5/QlikView/Querying-Data-from-within-a-file/m-p/1139109#M635078 <HTML><HEAD></HEAD><BODY><P>Maybe have a look at this document, it's 3 years old, but maybe it's still showing the general approach to load and link the facebook comments:</P><P><A href="https://community.qlik.com/docs/DOC-5179">FaceBook analisys with Word Cloud Chart</A></P></BODY></HTML> Tue, 24 May 2016 23:25:26 GMT https://community.qlik.com/t5/QlikView/Querying-Data-from-within-a-file/m-p/1139109#M635078 swuehl 2016-05-24T23:25:26Z Re: Querying Data from within a file https://community.qlik.com/t5/QlikView/Querying-Data-from-within-a-file/m-p/1139110#M635079 <HTML><HEAD></HEAD><BODY><P>Hi!!</P><P>Thanks for the reply... Do you know if there's any way I can open the file??</P><P>It says that it has been opened too many times or something... and I can't open it on my personal license nor on the one I have on a server...</P></BODY></HTML> Wed, 25 May 2016 13:35:15 GMT https://community.qlik.com/t5/QlikView/Querying-Data-from-within-a-file/m-p/1139110#M635079 2016-05-25T13:35:15Z Re: Querying Data from within a file https://community.qlik.com/t5/QlikView/Querying-Data-from-within-a-file/m-p/1139111#M635080 <HTML><HEAD></HEAD><BODY><P>The message seems to indicate that you are trying to open the file with your Personal Edition QlikView desktop version.</P><P></P><P>If you have access to a server, check if you can lease a license from that server. </P><P></P><P>A licensed QV desktop version should be able to open the document.</P></BODY></HTML> Wed, 25 May 2016 13:50:36 GMT https://community.qlik.com/t5/QlikView/Querying-Data-from-within-a-file/m-p/1139111#M635080 swuehl 2016-05-25T13:50:36Z Re: Querying Data from within a file https://community.qlik.com/t5/QlikView/Querying-Data-from-within-a-file/m-p/1139112#M635081 <HTML><HEAD></HEAD><BODY><P>File works fine directly from the link. Could you do a screen grab of the error you're getting?</P></BODY></HTML> Wed, 25 May 2016 13:51:23 GMT https://community.qlik.com/t5/QlikView/Querying-Data-from-within-a-file/m-p/1139112#M635081 ThornOfCrowns 2016-05-25T13:51:23Z Re: Querying Data from within a file https://community.qlik.com/t5/QlikView/Querying-Data-from-within-a-file/m-p/1139113#M635082 <HTML><HEAD></HEAD><BODY><P style="font-size: 13.3333px;">Got it to work! I had to use the "open from server" option <span class="lia-unicode-emoji" title=":grinning_face_with_big_eyes:">😃</span></P><P style="font-size: 13.3333px;">Nevertheless... my problem here is that there is so much information that I honestly dont know which part works for what I need. This is the same file that is used by the Facebook Connector from QVSource, and I've had the roughest time trying to transform it to the new connector...</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">That's why I need to understand the structure of queries within queries... Any ideas???</P></BODY></HTML> Wed, 25 May 2016 14:24:44 GMT https://community.qlik.com/t5/QlikView/Querying-Data-from-within-a-file/m-p/1139113#M635082 2016-05-25T14:24:44Z