Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
libinanto95
Contributor
Contributor

Help in fetching Previous value from the Table

Hey Folks,

 

I have a requirement as if the Current Year from ( Year table as from 2011 to 2019) and Current MonthData is not available on the particular field then I have the take the value from the previous month table, 

Assume that if i have a value on Oct 2018 and till Jun 2019 I have no value in between tables. So How should i apply logic in this case.

I need the Oct 2018 Value should be displayed on Jun 2019 field...

So how should I perform

 

My Exact Data is:

Load

Values, Month, Year

0.001, Jun , 2016

0.002, Jul, 2016

0.003, Aug, 2016

0     ,  Oct, 2016

0     ,  Nov, 2016

0     ,  Dec, 2016

0     ,  Jan, 2017

0     ,  Feb, 2017

0     ,  Mar, 2017

0     ,  Apr, 2017

0     ,  May, 2017

0     ,  Jun, 2017

 

Now I need the Value of Aug, 2016 as my Current month Value as my Current Month is Jun, 2017.

Now is my Question Clear?

 

 

Thanks in advance...!!!

3 Replies
gerry_hdm
Creator II
Creator II

hello,

you can the previous() function ?

 

 

libinanto95
Contributor
Contributor
Author

Hey Gerry, I tried Peek, Previous and even Pick but no Luck...

Can you help me with the exact query?

gerry_hdm
Creator II
Creator II

im not anderstand your  question,

ist the question

Month with the last  numerical value?

greeting Gerry