Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Silambarasan1306
Creator III
Creator III

Comparing Current day record with previous day ??

Hi All,

I have a table like below mentioned.

DateItem
4/1/2016A
4/1/2016B
4/2/2016B
4/2/2016C
4/3/2016C
4/3/2016D
4/3/2016E

on 1st april, A, B Items are available, On 2nd A item is not available. So, i need a status In Active. But new record C added on 2nd. So, for that i need a status Active. So, i need a final result below mentioned.

  

DateItemStatus
4/1/2016A
4/1/2016B
4/2/2016BNotActive(A)
4/2/2016CActive
4/3/2016CNotActive(B)
4/3/2016DActive
4/3/2016E

Active

Thank you

4 Replies
sunny_talwar

Are you envisioning this to be done in the script or front end of the application?

Silambarasan1306
Creator III
Creator III
Author

Hi Sunny,

This to be done in the script itself.

Thank you

sunny_talwar

Just so I understand this better, if we had data like this... what would be the output?

DateItem
4/1/2016A
4/1/2016B
4/1/2016C
4/2/2016B
4/2/2016C
4/2/2016D
4/2/2016E
4/3/2016E
4/4/2016A
4/5/2016B
Silambarasan1306
Creator III
Creator III
Author

Hi Sunny,

find the below mentioned

   

DateActive/InActive
4/1/2016    2
4/2/2016     1/1C- Active, A -Inactive
4/3/2016   2/1D,E - Active, B - InActive