Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear all,
I am working on creating a swimmer plot to visualize cancer drug clinical trial data. The objective is to display treatment duration along with key events such as dose reduction, interruption, and withdrawal, as well as tumor responses (SD, PR, CR) and patient status (Ongoing, DD, or EOT – End of Trial) at the end of each bar.
So far, I have been able to build a stacked bar chart to represent the treatment periods. However, I have not found a way to overlay symbols or markers to indicate responses and patient status on top of the bars.
I’ve attached the QVF file, along with my dataset and an example swimmer plot created in another software package (likely SAS), for reference. Any suggestions, examples, or guidance on how to achieve this in Qlik Sense would be greatly appreciated.
Thank you in advance for your help!
Best regards,
Harry Wang
Subject | StartDate | EndDate | DoseInterruption | Efficacy | EfficacyDate | Status |
101 | 2025-01-01 | 2025-01-10 | medication | CR | 2025-01-05 | Ongoing |
101 | 2025-02-01 | 2025-02-15 | interruption | PR | 2025-02-10 | EOT |
101 | 2025-03-01 | 2025-03-20 | reduction | SD | 2025-03-10 | DD |
102 | 2025-01-05 | 2025-01-25 | medication | PR | Ongoing | |
102 | 2025-02-10 | 2025-02-18 | medication | CR | 2025-02-15 | EOT |
103 | 2025-01-08 | 2025-01-12 | medication | SD | Ongoing | |
103 | 2025-02-01 | 2025-02-28 | reduction | CR | Ongoing | |
104 | 2025-01-15 | 2025-01-20 | medication | PD | DD | |
104 | 2025-02-05 | 2025-02-18 | medication | PR | Ongoing | |
105 | 2025-01-01 | 2025-01-05 | medication | SD | EOT | |
105 | 2025-01-10 | 2025-01-20 | Withdrawal | CR | 2025-01-15 | Ongoing |
Is the % change in the below video /chart sth that can help?
Not direct answer but a guidance:
There is link to the app as well
I don’t need the % change — I just want to show the treatment process and mark certain events with symbols. Thank you for your help!
No you do not but you may replace that with your mark.
I do not think you can have a native marks in the same way you have presented