I'm new to Qlikview and have a specific problem that highlights a broader issue that I'm not sure about yet.
The problem is whether it is possible to use lag values in a straight table i.e. To create the following:
My ultimate aim is to be able to create a column where I compare the Value with the lag value, but I want to get there in stages.
One solution would be to create another column as I load the data. But is that the best way of doing it? If the dataset were large it would slow down loading. In this situation the data is small, but I often work with big datasets.
it will returns the value of expression evaluated with the chart's dimension values as they appear on the row above the current row within a column segment in a table or, in the case of bitmap charts, in the chart's straight table equivalent