Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
New Contributor III

Show previous month data, when there is no record

Hey, here is the screenshot of my current pivot table (QVW file attached)

sample.PNG

What I am trying to achieve is something like:

sample2.PNG

If it is possible, I would like to be able to do that using expression.

Does anybody have any idea? thanks before

2 Replies
Highlighted
Honored Contributor III

Re: Show previous month data, when there is no record

Hi Mike,

remove '*Avg(1)' from Expression.

Regards,

Antonio

Highlighted
New Contributor III

Re: Show previous month data, when there is no record

Hi!

it wont work if I select only 1 period. it will show in all periodkd.PNG