Skip to main content
See why Qlik is a Leader in the 2024 Gartner® Magic Quadrant™ for Analytics & BI Platforms. Download Now
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

Period pivot table

Dear Experts,

Is there a way we can achieve the following ? :

The table goes by Report Date(transaction date) as the dimension and the measures are to be the sales on that day(row) and the sales of previous month on same day. So for an example, the first row we see below is 20/4/2016 which carries its value in column sales, in column sales last month, we are expecting the sales of 20/3/2016. Is this possible in a table that carries the date itself as the dimension? I know it is possible with any other dimension, but this case is tricky to solve.


Kindly Help.

Thanks 🙂

0 Replies