Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
nezuko_kamado
Creator
Creator

Can we add dropdowns to select data tables at sheet to compare varaiables' existing (flag)?

I simplified mydata tables here, but my actual data tables have thousands of IDs and multiple varaibles(columns) for over 24 months.

Capture.PNG

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. 

Capture2.PNG

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;

 

Labels (2)
1 Reply
Mario_De_Felipe
Luminary
Luminary

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