Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

silambarasan130
Contributor II

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
MVP
MVP

Re: Comparing Current day record with previous day ??

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

silambarasan130
Contributor II

Re: Comparing Current day record with previous day ??

Hi Sunny,

This to be done in the script itself.

Thank you

MVP
MVP

Re: Comparing Current day record with previous day ??

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
silambarasan130
Contributor II

Re: Comparing Current day record with previous day ??

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
Community Browser