Hi all,
I am trying to implement a feature for Comparison in Qlik sense. The data set has a column called refresh date which is basically everyday the data gets refreshed.
There is a ID , say location id, that can get added/removed during every refresh. There are other dimensions and measures too in the dataset.
The user request was to have two table charts, one table should have all the IDs(plus other dimensions and measures) that are present for Refresh date 1 that are not present in the Refresh date 2.
The other table should have all the IDs(plus other dimensions and measures) that are present in Refresh date 2 but not in Refresh date 1.
I have created two list box filters with states S1 and S2 and two table charts(as mentioned above) with the respective states.
I am stuck on how to exclude the data between these two tables/alternate states.
Please provide an approach to achieve this functionality