One Filter many fields

[tdegen_qlik]

I have patient healthcare data.  I would like to create ONE filter that affects many fields.

That is:  Suppose I have a master calendar (Year and Month).

When I select the year and month I want to see anything that may have happened during that period.

My Table looks like this:

PatientID (primary key)

PatientTransplantDate1  (blood transfusion therapy - could be given over multiple dates)

PatientTransplantDate2

PatientCarTDate1  (CAR-T infusion Therapy - given over multiple dates)

PatientCarTDate2

PatientCarTDate3

+ [200 more variables]

All of these date fields are on one (horizontal) table.   Any way to have one date selector to see which patients had any of these events during a chosen month?    Any suggestions would be much appreciated.

My solution is to split the table and call each date field an "EventDate" - but that would mean architecting the whole application (hundreds of variables and 50+ charts).   That is not ideal - nor is incorporating set analysis on every chart.

[Brett_Bleess]

I would have a look at the following Design Blog posts to see if they help you out:

https://community.qlik.com/t5/Qlik-Design-Blog/The-Master-Calendar/ba-p/1471527

https://community.qlik.com/t5/Qlik-Design-Blog/Canonical-Date/ba-p/1463578

Here is the base URL in case you wish to search this area further for other posts:

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Regards,
Brett