Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikviewsam
Creator
Creator

Previous Month value

Hi all,

I want to find previous month value

example

 

Year Month Sales
2016Jan 100
2016Feb200
2016Mar300
2016Apr400
2016May500
2016Jun600
2016Jul700
2016Aug800
2016Sep900
2016Oct1000
2016Nov1100
2016Dec1200
2017Jan 1300
2017Feb1400
2017Mar1500

1) Currently it should show value for Feb 2017

2) If i select Jan 2017 it should show Dec 2016 value

thanks in advance

.

1 Reply
swuehl
MVP
MVP