Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I want to take a data source .. load it and save off multiple data files on the fly with different content based on the query I use .. (i.e. different group by clauses and where clauses).
Once files are created use indicidual data files in different tabs containing dashboards.
Is that possible ?
Yes it is possible by using the store and drop table command as required
Load the data from your source and save it to a QVD file using the STORE command.
Your various QlikView apps can then load the data from the QVD file.
You may not need to use group by to aggregate the data as QlikView will sum the data very fast as the data is held in memory. Try it first before aggregating the data.
Thanks for the quick response ..