One Filter many fields

tdegen_qlik — Wed, 04 Mar 2020 18:09:45 GMT

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.

Re: One Filter many fields

Brett_Bleess — Thu, 02 Apr 2020 11:50:23 GMT

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

topic One Filter many fields in QlikView

One Filter many fields

Re: One Filter many fields