Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have simplified my requirement.
Let's say we have the data below
Month | Sales |
1 | 1000 |
2 | 2000 |
3 | 3000 |
4 | 4000 |
5 | 5000 |
Now I want to create a straight table in Qlik as below.
Month | This Month Sales | Next Month Sales |
1 | 1000 | 2000 |
2 | 2000 | 3000 |
3 | 3000 | 4000 |
4 | 4000 | 5000 |
The month field should be in the straight table as the first dimension. How can I achieve this? I am unable to get the next month sales in this table because we have the Month dimension part of this table??