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.
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.
