topic Temporary Tables in QlikView https://community.qlik.com/t5/QlikView/Temporary-Tables/m-p/1271243#M399879 <HTML><HEAD></HEAD><BODY><P>Hi all, </P><P></P><P>Does qlik view supports something like "temporary tables" in SQL ?</P><P>So data is visible just for current user session ?</P><P></P><P>Requirements:</P><P>User log in and choose several parameters for model.</P><P>User should be able to run load script on demand (populate just temp tables).</P><P>Data will be loaded from external system (heavy financial calculation)</P><P>All data will be dropped when client session terminates.</P><P></P><P>In general we cannot load all data for all users by script to qlik view. </P><P>There are many combination of input parameters so result of calculation is always different.</P><P></P><P>Thanks in advance for any suggestions or help</P></BODY></HTML> Fri, 02 Dec 2016 12:31:58 GMT 2016-12-02T12:31:58Z Temporary Tables https://community.qlik.com/t5/QlikView/Temporary-Tables/m-p/1271243#M399879 <HTML><HEAD></HEAD><BODY><P>Hi all, </P><P></P><P>Does qlik view supports something like "temporary tables" in SQL ?</P><P>So data is visible just for current user session ?</P><P></P><P>Requirements:</P><P>User log in and choose several parameters for model.</P><P>User should be able to run load script on demand (populate just temp tables).</P><P>Data will be loaded from external system (heavy financial calculation)</P><P>All data will be dropped when client session terminates.</P><P></P><P>In general we cannot load all data for all users by script to qlik view. </P><P>There are many combination of input parameters so result of calculation is always different.</P><P></P><P>Thanks in advance for any suggestions or help</P></BODY></HTML> Fri, 02 Dec 2016 12:31:58 GMT https://community.qlik.com/t5/QlikView/Temporary-Tables/m-p/1271243#M399879 2016-12-02T12:31:58Z Re: Temporary Tables https://community.qlik.com/t5/QlikView/Temporary-Tables/m-p/1271244#M399880 <HTML><HEAD></HEAD><BODY><P>No, there are no temporary tables. But perhaps you can use <A _jive_internal="true" href="https://community.qlik.com/blogs/qlikviewdesignblog/2012/11/08/qlikview-112-and-direct-discovery">Direct Discovery</A> to retrieve the data for the user as needed in real time from the source database.</P></BODY></HTML> Mon, 05 Dec 2016 12:02:36 GMT https://community.qlik.com/t5/QlikView/Temporary-Tables/m-p/1271244#M399880 Gysbert_Wassenaar 2016-12-05T12:02:36Z