Hi All,
I have below table in qlikview with GL entries. The requirement here is prior period value for income/expense should be shown in Equity row of Prior Period / Month column. How this can be achieved ? Is there a way using set analysis or Aggr() in this case.
Dimensions are GL Category & Expression is using sum of amount with specific GL Category.
| |
Month1 |
Prior Period |
Month2 |
Prior Period |
Month3 |
| Asset |
100 |
|
200 |
|
200 |
| Current Liabilities |
25 |
|
25 |
|
25 |
| Equity |
50+10 |
|
15+5 |
|
15 |
| Current Income/Expense |
20 |
10 |
21 |
5 |
21 |
