Track Latest value

[sirivikram1506]

Hi All,

I was trying to show last value in straight table from source table in qlik.

My table look like:

Email,                                    status,                    Date 

abc@gmail.com              CANC                    02/10/2018

abc@gmail.com            CANC                      05/07/2019

abc@ gmail.com           TXNS                     09/07/2019

xyz@gmail.com               CANC       09/07/2019

qrs@gmail.com        CANC                    10/07/2019

klm@gmail.com         CANC                  20/07/2019

user1@gmail.com    CANC             20/07/2019

User1@gmail.com    TXNS       21/07/2019

Like above....!.

So from this table i need to track info like The user should be registred in Jul 2019 and his status should be CANC and he should not have any other  statuses befor jul 2019  and in jul 2019 also.

please help in this.....!.

Thanks,

Vikramk

[udayreddy06 · Accepted solution]

Hello Sirivikam,

PFA file.

Thanks,
Uday

[sirivikram1506]

Hi Uday,

it's unable to load into Qliksense,

Can you please post that  script or formula.

thanks,

Vikram

[udayreddy06]

Hello,

PFA file.

Thanks,
Uday