Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
disadvantages of pivot and stright?
Hello manojqlik ,
Pivot tables work with the data available at the time of creation, though, and may not immediately update when the data changes or new data become available.
Instead, you may need to refresh pivot tables or even completely recreate the tables after data changes in order to reflect the most current information.
Hi,
If you don't need to create hierarchical concept groups (such as Contry, State, City...) I sugest you use a straight table.
The reason for this is because with large volumes of data, the pivot table has a bigger impact on performance. It is one of the most costly QlikView objects regarding performance.