Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I simplified mydata tables here, but my actual data tables have thousands of IDs and multiple varaibles(columns) for over 24 months.
What I want to compare is the existance of IDs over months, maybe, within a window of 12 month difference(1, 3 ,6 and 12 month flags).
In order to do so, can I add drop downs that selecting data tables at the sheet and calculating cancelation rate or delivered rate between the selected two months? like as below.
If not, what would be your recommendation that I can create at load editor?
I used flag for two tables, then I had to create too many combinations of tables for over 24 months, and which is better avoided....
Check2Tables:
loadID, IDAug Resident AugTable;
Join(Check2Tables) load ID, IDSep Resident SepTable;
Left Join(Check2Tables) loadID, if(IDAug =IDSep, 'Remained', 'Removed') as Flag
Resident Check2Tables;
Hi @nezuko_kamado ,
maybe you could review this: https://help.qlik.com/en-US/sense/August2022/Subsystems/Hub/Content/Sense_Hub/Visualizations/alterna...
I think is a better way to perform comparative analysis using the same field.
Hope it helps!
Mario