The biggest limitation of QLIKVIEW in data point of view, is that all the data should be stored in RAM. As big data introduction data is too huge, so QLIKVIEW introduce a hybrid approach. In which QLIKVIEW stores the dimension in the RAM, while measures or the numeric values are stored in the database you want.
Basically aggregation of measures are run on the database not in memory, which reduce the RAM usage. It will be used when our database speed is good enough.
QLIKVIEW introduce the new type of query for these kind of requirement “Direct Query”.
It has three types of field
1) Dimension:- which are used for association
2) Measure: - on which we perform the aggregation
3) Detail:- those field which can’t be used for association or aggregation. Like Comments.
The script look like below
The unique values of Dimension will be fetched in the QVW, and that can be used for creating association between data and other data.