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

nezuko_kamado — Tue, 13 Sep 2022 22:01:07 GMT

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;

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

Mario_De_Felipe — Mon, 26 Sep 2022 06:16:27 GMT

Hi @nezuko_kamado ,

maybe you could review this: https://help.qlik.com/en-US/sense/August2022/Subsystems/Hub/Content/Sense_Hub/Visualizations/alternate-states-comparative-analysis.htm

I think is a better way to perform comparative analysis using the same field.

Hope it helps!

Mario

topic Re: Can we add dropdowns to select data tables at sheet to compare varaiables' existing (flag)? in App Development

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

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