Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i have to calculate view for months for this i have to subtract views for priviouse month from current month.
Raw Data:
| Type | Jan | Feb | Mar | Apr | May |
| abc | 1000 | 1060 | 1120 | 1180 | 1240 |
| bca | 2000 | 2040 | 2080 | 2120 | 2160 |
| cab | 3000 | 3070 | 3140 | 3210 | 3280 |
| ghy | 4000 | 4020 | 4040 | 4060 | 4080 |
| ghj | 5000 | 5080 | 5160 | 5240 | 5320 |
| rty | 6000 | 6090 | 6180 | 6270 | 6360 |
| hio | 7000 | 7020 | 7040 | 7060 | 7080 |
| hdo | 8000 | 8010 | 8020 | 8030 | 8040 |
| gft | 9000 | 9025 | 9050 | 9075 | 9100 |
calculation:
| View(Jan) | View(Feb) | View(Mar) | View(Apr) |
| 60 | 60 | 60 | 60 |
| 40 | 40 | 40 | 40 |
| 70 | 70 | 70 | 70 |
| 20 | 20 | 20 | 20 |
| 80 | 80 | 80 | 80 |
| 90 | 90 | 90 | 90 |
| 20 | 20 | 20 | 20 |
| 10 | 10 | 10 | 10 |
| 25 | 25 | 25 | 25 |
like for Jan view = Feb-jan
for Feb view= Mar-Feb
...................
Please suggest how to do this at time of loading or in expression in qlikview line chart and table.
A sample implementation is attached. Hope this helps.