Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
ramanannad
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.

sample.png

Kindly Help.

Thanks 🙂

0 Replies