QlikSense Table

[psenthilbtech]

Hi Team ,

I have to create a report for a particular scenario- 

Option1:

Step 1. Client Upload Form
Step2 . Approve

Option 2 :

Step 1. Client Upload Form
Step2 . Rejected
Step 3. Clent Upload Form again
Step 4. Approve

Option 3:
Step 1. Client Upload Form
Step2 . Rejected and they are uploading againg

Sample Data

FormID             UplodadedDate                Status
001                     01/01/2019                      Approved
002                      01/01/2019                     Rejected
003                    01/01/2019                     Approved
004                    01/01/2019                           Rejected
005                    01/01/2019                              Approved
006                    01/01/2019                             Approved
002                     07/01/2019                        Approved
009                      01/01/2019                              Rejected

Required Output
Should identify the forms that are rejected and not uploaded again

[micheledenardi]

RawData:
NoConcatenate
Load * Inline [
FormID,UplodadedDate,Status
001,01/01/2019,Approved
002,01/01/2019,Rejected
003,01/01/2019,Approved
004,01/01/2019,Rejected
005,01/01/2019,Approved
006,01/01/2019,Approved
002,07/01/2019,Approved
009,01/01/2019,Rejected
];


Approved:
load Distinct
	FormID as [FormID Approved]
Resident RawData
	Where Status='Approved';

Rejected:
NoConcatenate
Load *
Resident RawData
	Where not Exists([FormID Approved],FormID);
	
Drop Table RawData;
Drop Table Approved;