topic Right data structure and load in QlikView https://community.qlik.com/t5/QlikView/Right-data-structure-and-load/m-p/322095#M1198107 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I need to manage the load from a SQL table that contains fe ProjectCode, ProjectDescription, Year, Month, ProjectAmount, ProjectCosts, ProjectInvoiced. I can have temporary data and in a second moment definitive data. I think to create a flag for my SQL table and alternatively an analogue SQL table. This choice depends from the load to implement in QV. I must show two charts, the first one with temporary data (first fact table) and the second one with definitive data.</P><P>Which is the better solution? Managing a flag in the original SQL table, or managing two SQL tables and two different load (concatenated?) in QV?</P><P>Any helps to me, please? Thanks</P></BODY></HTML> Fri, 15 Apr 2011 16:38:08 GMT 2011-04-15T16:38:08Z Right data structure and load https://community.qlik.com/t5/QlikView/Right-data-structure-and-load/m-p/322095#M1198107 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I need to manage the load from a SQL table that contains fe ProjectCode, ProjectDescription, Year, Month, ProjectAmount, ProjectCosts, ProjectInvoiced. I can have temporary data and in a second moment definitive data. I think to create a flag for my SQL table and alternatively an analogue SQL table. This choice depends from the load to implement in QV. I must show two charts, the first one with temporary data (first fact table) and the second one with definitive data.</P><P>Which is the better solution? Managing a flag in the original SQL table, or managing two SQL tables and two different load (concatenated?) in QV?</P><P>Any helps to me, please? Thanks</P></BODY></HTML> Fri, 15 Apr 2011 16:38:08 GMT https://community.qlik.com/t5/QlikView/Right-data-structure-and-load/m-p/322095#M1198107 2011-04-15T16:38:08Z