topic Re: New diagram - data from different tables in QlikView https://community.qlik.com/t5/QlikView/New-diagram-data-from-different-tables/m-p/501484#M556506 <HTML><HEAD></HEAD><BODY><P>Thanks!</P><P>That would be ideal. That way I could delete the qvd right after using it, so our personell data would be totally safe.</P><P></P><P>Best regards,</P><P></P><P>DataNibbler</P></BODY></HTML> Mon, 22 Jul 2013 08:40:21 GMT datanibbler 2013-07-22T08:40:21Z New diagram - data from different tables https://community.qlik.com/t5/QlikView/New-diagram-data-from-different-tables/m-p/501481#M556503 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>combining data from different tables is generally easy with QlikView, but here is a challenge:</P><P>- I want to build a barchart with a nr. of (self-defined) categories as the dimension and a nr. of employees within those categories as formula.</P><P>- That works fine so far, querying a database table where data is updated daily.</P><P>&lt;=&gt; There is no date_field in that table´, only a month - one record per month, updated daily, meaning this month's value is updated daily and will finally remain on the value of the last day of this month.</P><P>&lt;=&gt; This means that, while I can display the values in different months or a very current value, anything inbetween (e.g. cw 27 (we are in 29)) is impossible using that table.</P><P></P><P>=&gt; For this reason, I have, in order to have more data points, to query another table where there is a record for every day - I will thus select the value for last month from the one table and add the daily values from the 1st of this month till the day selected from the other table.</P><P></P><P>The best I can come up with is doing a RESIDENT LOAD from both tables and creating a qvd in which I will have more detailed data for the current month - one value each for past months is okay. The thing is, this is personell data and I don't really want to create a qvd, unless I can immediately delete it so that it can't be accessed anymore.</P><P>Can anyone come up with a better idea?</P><P></P><P>Thanks a lot!</P><P>Best regards,</P><P></P><P>DataNibbler</P></BODY></HTML> Fri, 19 Jul 2013 13:43:10 GMT https://community.qlik.com/t5/QlikView/New-diagram-data-from-different-tables/m-p/501481#M556503 datanibbler 2013-07-19T13:43:10Z Re: New diagram - data from different tables https://community.qlik.com/t5/QlikView/New-diagram-data-from-different-tables/m-p/501482#M556504 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>asking in another way: Can anyone give me a hint as to how I could implement a function to delete the qvd file upon closing the app?</P><P></P><P>Thanks a lot!</P><P>Best regards,</P><P></P><P>DataNibbler</P></BODY></HTML> Mon, 22 Jul 2013 07:49:20 GMT https://community.qlik.com/t5/QlikView/New-diagram-data-from-different-tables/m-p/501482#M556504 datanibbler 2013-07-22T07:49:20Z Re: New diagram - data from different tables https://community.qlik.com/t5/QlikView/New-diagram-data-from-different-tables/m-p/501483#M556505 <HTML><HEAD></HEAD><BODY><P>This is possible per execute:</P><P></P><P><A _jive_internal="true" class="loading active_link" href="https://community.qlik.com/message/100850#100850" title="http://community.qlik.com/message/100850#100850">http://community.qlik.com/message/100850#100850</A></P><P></P><P>- Marcus</P></BODY></HTML> Mon, 22 Jul 2013 08:11:52 GMT https://community.qlik.com/t5/QlikView/New-diagram-data-from-different-tables/m-p/501483#M556505 marcus_sommer 2013-07-22T08:11:52Z Re: New diagram - data from different tables https://community.qlik.com/t5/QlikView/New-diagram-data-from-different-tables/m-p/501484#M556506 <HTML><HEAD></HEAD><BODY><P>Thanks!</P><P>That would be ideal. That way I could delete the qvd right after using it, so our personell data would be totally safe.</P><P></P><P>Best regards,</P><P></P><P>DataNibbler</P></BODY></HTML> Mon, 22 Jul 2013 08:40:21 GMT https://community.qlik.com/t5/QlikView/New-diagram-data-from-different-tables/m-p/501484#M556506 datanibbler 2013-07-22T08:40:21Z