topic Help in fetching Previous value from the Table in QlikView

Help in fetching Previous value from the Table

libinanto95 — Fri, 02 Aug 2019 05:36:39 GMT

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...!!!

Re: Help in fetching Previous value from the Table

gerry_hdm — Fri, 02 Aug 2019 06:19:44 GMT

hello,

you can the previous() function ?

Re: Help in fetching Previous value from the Table

libinanto95 — Fri, 02 Aug 2019 09:10:08 GMT

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

Can you help me with the exact query?

Re: Help in fetching Previous value from the Table

gerry_hdm — Fri, 02 Aug 2019 09:25:56 GMT

im not anderstand your question,

ist the question

Month with the last numerical value?

greeting Gerry