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.