i use generic load but the data separated for each date. the problem is how to union them to one table and create dynamic table box or straight table without manually add new date field to table box properties on presentation layer, because user will add new data daily and didn't know how use qlikview, they know only reload and export excel.
Please Answer this without qvw file, because i use Personal Edition. Thanks
Transform your data in straight table. You have to use set statement in main script. Please define file path in the set statement.Use '*' in the file name at the end of the load statement. This will fetch every file starts with the name & automatically update the data.
If you don't transform the data tables using GENERIC LOAD, new data records will just be added to the table shown as first table in the OP, no new tables / fields are generated.
New data for new dates are hence just new field values, so using a pivot table will just add the new data to the dimensional values, without the need to add a new field as dimension or expression.
IMO, this is how we should build the charts (no need to change the dimensions / expressions when new data is loaded).
i'm success now union all table from generic load to one table, but how i can automaticaly add new field(Date) as column to straight table without add it from properties, i try it on calculated dimension or expression with subfield() but it just add spesific date base on index
