How to achieve A/B Comparison view in a Single table in Qlikview ?

[prathapkoti]

I need to implement a requirement of an end user who wants an A/B Comparison view to be made available in a Qlikview Table.

The Input Data is in the format as provided in Sampl_DATAInput.xlsx, which is attached. This data can be assumed to be the underlying associated data for the purpose of this issue.

The user wants to select A and B Dates as filters, based on the "Date" Column in the Excel sheet. The A Date and the B Date are mutually exclusive. Based on the A and B Date selections, there would be two resultant data columns, displayed side-by-side.

The expected Result is shown in Expected Output Model.xlsx, which is attached.

Can you please provide insight into how this problem can be implemented? The selection of two mutually exclusive dates to display field values side-by-side representing each date selection is problematic for me. Please advise.