I am making an app with Qlik Sense, I will use an incremental load and the data will likely change over time (new metrics added). For maintenance reasons, I thought of storing the table longitudinally (DIMENSIONS|METRIC NAME|VALUE) but I am not sure of the implications of such an approach on the visualisation side.
The doubts wandering my mind are:
As a side note I read the presentation attached to this document Performance and Optimization Best Practices in QlikView & Qlik Sense and I understood that the memory usage of the data depends on the unique values included. However, I loaded 300k rows times 60 variables both in wide and long and the memory difference is around 50% (16000KB wide format vs 24000KB long).
I include a minimal example in the attached QVF.
Any advice is welcome.