Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hello Sirivikam,
PFA file.
Thanks,
Uday
Hi Uday,
it's unable to load into Qliksense,
Can you please post that script or formula.
thanks,
Vikram
Hello,
PFA file.
Thanks,
Uday