Discussion board where members can get started with Qlik Sense.
Below is the status i want to match at script level and the result will should give as,
Sign Triggered = sent + Declined +Failed +Voided
Original Error : no document found
Please let me know how to get this.
Go to Solution.
I guess you want to map some values to other values. A mapping table and ApplyMap should do that trick:
MAPPING LOAD [
Envelope STATUS ,Remarks
Original Error : no document found ,Sign Completed
sent ,Sign Triggered
Completed ,Sign Completed
Declined ,Sign Triggered
Failed ,Sign Triggered
Signed Envelope ,Sign Completed
Voided ,Sign Triggered
ApplyMap('mapStatus',[Envelope STATUS]) as Mapped_Status