topic Problem with Previous function in QlikView

Problem with Previous function

Anonymous — Wed, 26 Jul 2017 06:34:43 GMT

Hi,

I have a scenario where if the value of ID change from Yes(last month) to No (current month) then its status is yes.

I have created the mapping table for the same & perform the applymap after performing the group by using ID and month & order by ID and timestamp

I want to calculate the single status of ID for particular month,but we are getting double status for same ID

ID	Month	Value	Status	TimeStamp
111	Jul-17	No	F	7/13/2017 11:05
111	Jul-17	No	T	7/12/2017 11:46
111	Jun-17	Yes	F	6/8/2017 11:34
111	May-17	Yes	F	5/1/2017 16:00
111	May-17	Yes	F	5/2/2017 16:00
111	May-17	Yes	F	5/3/2017 16:00
111	May-17	Yes	F	5/4/2017 16:00
111	May-17	Yes	F	5/5/2017 16:00
111	May-17	Yes	F	5/8/2017 16:00
111	May-17	Yes	F	5/9/2017 16:00
111	May-17	Yes	F	5/10/2017 16:00
111	May-17	Yes	F	5/10/2017 17:06

Required output

ID	Month	Value	Status	TimeStamp
111	Jul-17	No	T	7/13/2017 11:05
111	Jun-17	Yes	F	6/8/2017 11:34
111	May-17	Yes	F	5/1/2017 16:00
111	May-17	Yes	F	5/2/2017 16:00
111	May-17	Yes	F	5/3/2017 16:00
111	May-17	Yes	F	5/4/2017 16:00
111	May-17	Yes	F	5/5/2017 16:00
111	May-17	Yes	F	5/8/2017 16:00
111	May-17	Yes	F	5/9/2017 16:00
111	May-17	Yes	F	5/10/2017 16:00
111	May-17	Yes	F	5/10/2017 17:06

Re: Problem with Previous function

sunny_talwar — Wed, 26 Jul 2017 11:46:59 GMT

Not sure I understand the need for Mapping Table? What exactly are you doing with it? Also, I am not sure I understand the output you are looking to get.... Can you explain the logic?

Re: Problem with Previous function

paulferguson80 — Wed, 26 Jul 2017 12:19:14 GMT

Hi Shweta,

I believe this may be what you are trying to do?

Using the previous function you can do the comparison, however i would be careful of 2 points

1 - the start of the file as this will always be null so you will need to default it

2 - the ordering of the data i.e. you may need to change the ordering of the data from the source to get the grouping correct when you have multiple id's and also nest the previous function on the id's to cope with when they change in the data.

Hope this helps

Ta Paul

Re: Problem with Previous function

Anonymous — Thu, 27 Jul 2017 04:23:41 GMT

please the required output sheet