Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
Highlighted
ramanannad
New 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.

sample.png

Kindly Help.

Thanks 🙂

Tags (2)