EGT05_QTCAT

ECG Actual Values and Changes from Baseline by Visit

---

Output

Standard Table

Preview

split_fun <- drop_split_levels

lyt <- basic_table(show_colcounts = TRUE) %>%
  split_cols_by("ARM") %>%
  split_rows_by(
    "PARAM",
    split_label = obj_label(adeg_f$PARAM),
    split_fun = split_fun,
    label_pos = "topleft"
  ) %>%
  split_rows_by(
    "AVISIT",
    split_label = obj_label(adeg_f$AVISIT),
    split_fun = split_fun,
    label_pos = "topleft"
  ) %>%
  analyze_vars(
    vars = c("AVALCAT1", "CHGCAT1"),
    var_labels = c("Value at Visit", "Change from Baseline")
  ) %>%
  append_topleft("    Category")

result <- build_table(lyt = lyt, df = adeg_f, alt_counts_df = adsl) %>%
  prune_table()

result

Parameter                                                             
  Analysis Visit             A: Drug X    B: Placebo    C: Combination
    Category                  (N=134)       (N=134)        (N=132)    
——————————————————————————————————————————————————————————————————————
QT Duration                                                           
  BASELINE                                                            
    Value at Visit                                                    
      n                         134           134            132      
      <=450 msec            115 (85.8%)   117 (87.3%)    104 (78.8%)  
      >450 to <=480 msec     6 (4.5%)      10 (7.5%)       9 (6.8%)   
      >480 to <= 500 msec     4 (3%)       3 (2.2%)        6 (4.5%)   
      >500 msec              9 (6.7%)       4 (3%)        13 (9.8%)   
  WEEK 1 DAY 8                                                        
    Value at Visit                                                    
      n                         134           134            132      
      <=450 msec            113 (84.3%)   106 (79.1%)    106 (80.3%)  
      >450 to <=480 msec     10 (7.5%)     10 (7.5%)      11 (8.3%)   
      >480 to <= 500 msec     4 (3%)        4 (3%)         3 (2.3%)   
      >500 msec              7 (5.2%)     14 (10.4%)      12 (9.1%)   
    Change from Baseline                                              
      n                         134           134            132      
      <=30 msec             76 (56.7%)     75 (56%)       75 (56.8%)  
      >30 to <=60 msec       7 (5.2%)      13 (9.7%)      11 (8.3%)   
      >60 msec              51 (38.1%)    46 (34.3%)      46 (34.8%)  
  WEEK 2 DAY 15                                                       
    Value at Visit                                                    
      n                         134           134            132      
      <=450 msec            111 (82.8%)   114 (85.1%)    112 (84.8%)  
      >450 to <=480 msec     10 (7.5%)     9 (6.7%)        9 (6.8%)   
      >480 to <= 500 msec    7 (5.2%)      2 (1.5%)        5 (3.8%)   
      >500 msec              6 (4.5%)      9 (6.7%)        6 (4.5%)   
    Change from Baseline                                              
      n                         134           134            132      
      <=30 msec              71 (53%)     87 (64.9%)      89 (67.4%)  
      >30 to <=60 msec       11 (8.2%)     9 (6.7%)        9 (6.8%)   
      >60 msec              52 (38.8%)    38 (28.4%)      34 (25.8%)  
  WEEK 3 DAY 22                                                       
    Value at Visit                                                    
      n                         134           134            132      
      <=450 msec            106 (79.1%)   112 (83.6%)    118 (89.4%)  
      >450 to <=480 msec     13 (9.7%)     7 (5.2%)        3 (2.3%)   
      >480 to <= 500 msec     4 (3%)       5 (3.7%)        2 (1.5%)   
      >500 msec              11 (8.2%)     10 (7.5%)       9 (6.8%)   
    Change from Baseline                                              
      n                         134           134            132      
      <=30 msec              63 (47%)     80 (59.7%)      81 (61.4%)  
      >30 to <=60 msec      14 (10.4%)      8 (6%)        11 (8.3%)   
      >60 msec              57 (42.5%)    46 (34.3%)      40 (30.3%)  
  WEEK 4 DAY 29                                                       
    Value at Visit                                                    
      n                         134           134            132      
      <=450 msec            117 (87.3%)   103 (76.9%)    114 (86.4%)  
      >450 to <=480 msec     7 (5.2%)     14 (10.4%)       6 (4.5%)   
      >480 to <= 500 msec     4 (3%)       7 (5.2%)        3 (2.3%)   
      >500 msec              6 (4.5%)      10 (7.5%)       9 (6.8%)   
    Change from Baseline                                              
      n                         134           134            132      
      <=30 msec              79 (59%)     80 (59.7%)      79 (59.8%)  
      >30 to <=60 msec       11 (8.2%)     7 (5.2%)       10 (7.6%)   
      >60 msec              44 (32.8%)    47 (35.1%)      43 (32.6%)  
  WEEK 5 DAY 36                                                       
    Value at Visit                                                    
      n                         134           134            132      
      <=450 msec            107 (79.9%)   117 (87.3%)    112 (84.8%)  
      >450 to <=480 msec    16 (11.9%)     5 (3.7%)       13 (9.8%)   
      >480 to <= 500 msec    5 (3.7%)      9 (6.7%)        3 (2.3%)   
      >500 msec              6 (4.5%)      3 (2.2%)         4 (3%)    
    Change from Baseline                                              
      n                         134           134            132      
      <=30 msec             72 (53.7%)    82 (61.2%)      73 (55.3%)  
      >30 to <=60 msec       10 (7.5%)     11 (8.2%)      11 (8.3%)   
      >60 msec              52 (38.8%)    41 (30.6%)      48 (36.4%)  

Try this using WebR

Experimental use!

WebR is a tool allowing you to run R code in the web browser. Modify the code below and click run to see the results. Alternatively, copy the code and click here to open WebR in a new tab.

Data Setup

library(tern)
library(dplyr)

adsl <- random.cdisc.data::cadsl
adeg <- random.cdisc.data::cadeg

# Ensure character variables are converted to factors and empty strings and NAs are explicit missing levels.
adsl <- df_explicit_na(adsl)
adeg <- df_explicit_na(adeg)

adeg_labels <- var_labels(adeg)
adeg_f <- adeg %>%
  filter(
    PARAMCD == "QT",
    ANL01FL == "Y"
  ) %>%
  mutate(
    AVALCAT1 = case_when(
      AVAL <= 450 ~ "<=450 msec",
      AVAL <= 480 ~ ">450 to <=480 msec",
      AVAL <= 500 ~ ">480 to <= 500 msec",
      AVAL > 500 ~ ">500 msec",
      is.na(AVAL) ~ "<Missing>"
    ),
    CHGCAT1 = case_when(
      CHG <= 30 ~ "<=30 msec",
      CHG <= 60 ~ ">30 to <=60 msec",
      CHG > 60 ~ ">60 msec",
      is.na(CHG) ~ "<Missing>"
    )
  ) %>%
  mutate(
    AVALCAT1 = factor(
      AVALCAT1,
      levels = c(
        "<=450 msec",
        ">450 to <=480 msec",
        ">480 to <= 500 msec",
        ">500 msec",
        "<Missing>"
      )
    ),
    CHGCAT1 = factor(
      CHGCAT1,
      levels = c(
        "<=30 msec",
        ">30 to <=60 msec",
        ">60 msec",
        "<Missing>"
      )
    )
  ) %>%
  var_relabel(
    AVALCAT1 = "Value at Visit",
    CHGCAT1 = "Change from Baseline"
  )

teal App

Preview

library(teal.modules.clinical)

## Data reproducible code
data <- teal_data()
data <- within(data, {
  library(dplyr)

  ADSL <- random.cdisc.data::cadsl
  ADEG <- random.cdisc.data::cadeg

  # Ensure character variables are converted to factors and empty strings and NAs are explicit missing levels.
  ADSL <- df_explicit_na(ADSL)
  ADEG <- df_explicit_na(ADEG)
  adeg_labels <- col_labels(ADEG)

  ADEG <- ADEG %>%
    filter(
      ANL01FL == "Y" # no need to filter for PARAMCD here
    ) %>%
    mutate(
      AVALCAT1 = case_when(
        AVAL <= 450 ~ "<=450 msec",
        AVAL <= 480 ~ ">450 to <=480 msec",
        AVAL <= 500 ~ ">480 to <= 500 msec",
        AVAL > 500 ~ ">500 msec",
        is.na(AVAL) ~ "<Missing>"
      ),
      CHGCAT1 = case_when(
        CHG <= 30 ~ "<=30 msec",
        CHG <= 60 ~ ">30 to <=60 msec",
        CHG > 60 ~ ">60 msec",
        is.na(CHG) ~ "<Missing>"
      )
    ) %>%
    mutate(
      AVALCAT1 = factor(
        AVALCAT1,
        levels = c(
          "<=450 msec",
          ">450 to <=480 msec",
          ">480 to <= 500 msec",
          ">500 msec",
          "<Missing>"
        )
      ),
      CHGCAT1 = factor(
        CHGCAT1,
        levels = c(
          "<=30 msec",
          ">30 to <=60 msec",
          ">60 msec",
          "<Missing>"
        )
      )
    )
  col_labels(ADEG) <- c(
    adeg_labels,
    "AVALCAT1" = "Value at Visit",
    "CHGCAT1" = "Change from Baseline"
  )
})
datanames <- c("ADSL", "ADEG")
datanames(data) <- datanames

Warning: `datanames<-()` was deprecated in teal.data 0.7.0.
ℹ invalid to use `datanames()<-` or `names()<-` on an object of class
  `teal_data`. See ?names.teal_data

join_keys(data) <- default_cdisc_join_keys[datanames]

## Reusable Configuration For Modules
ADSL <- data[["ADSL"]]
ADEG <- data[["ADEG"]]

## Setup App
app <- init(
  data = data,
  modules = modules(
    tm_t_summary_by(
      label = "ECG Actual Values and Changes from Baseline by Visit",
      dataname = "ADEG",
      arm_var = choices_selected(
        choices = variable_choices(ADSL, c("ARM", "ARMCD")),
        selected = "ARM"
      ),
      by_vars = choices_selected(
        choices = variable_choices(ADEG, c("PARAM", "AVISIT")),
        selected = c("AVISIT")
      ),
      summarize_vars = choices_selected(
        choices = variable_choices(ADEG, c("AVALCAT1", "CHGCAT1")),
        selected = c("AVALCAT1", "CHGCAT1")
      ),
      useNA = "ifany",
      paramcd = choices_selected(
        choices = value_choices(ADEG, "PARAMCD", "PARAM"),
        selected = "QT"
      )
    )
  )
)

shinyApp(app$ui, app$server)

Try this using shinylive

Experimental use!

shinylive allow you to modify to run shiny application entirely in the web browser. Modify the code below and click re-run the app to see the results. The performance is slighly worse and some of the features (e.g. downloading) might not work at all.

#| '!! shinylive warning !!': |
#|   shinylive does not work in self-contained HTML documents.
#|   Please set `embed-resources: false` in your metadata.
#| standalone: true
#| viewerHeight: 800
#| editorHeight: 200
#| components: [viewer, editor]
#| layout: vertical

# -- WEBR HELPERS --
options(webr_pkg_repos = c("r-universe" = "https://insightsengineering.r-universe.dev", getOption("webr_pkg_repos")))

# -- APP CODE --
library(teal.modules.clinical)

## Data reproducible code
data <- teal_data()
data <- within(data, {
  library(dplyr)

  ADSL <- random.cdisc.data::cadsl
  ADEG <- random.cdisc.data::cadeg

  # Ensure character variables are converted to factors and empty strings and NAs are explicit missing levels.
  ADSL <- df_explicit_na(ADSL)
  ADEG <- df_explicit_na(ADEG)
  adeg_labels <- col_labels(ADEG)

  ADEG <- ADEG %>%
    filter(
      ANL01FL == "Y" # no need to filter for PARAMCD here
    ) %>%
    mutate(
      AVALCAT1 = case_when(
        AVAL <= 450 ~ "<=450 msec",
        AVAL <= 480 ~ ">450 to <=480 msec",
        AVAL <= 500 ~ ">480 to <= 500 msec",
        AVAL > 500 ~ ">500 msec",
        is.na(AVAL) ~ "<Missing>"
      ),
      CHGCAT1 = case_when(
        CHG <= 30 ~ "<=30 msec",
        CHG <= 60 ~ ">30 to <=60 msec",
        CHG > 60 ~ ">60 msec",
        is.na(CHG) ~ "<Missing>"
      )
    ) %>%
    mutate(
      AVALCAT1 = factor(
        AVALCAT1,
        levels = c(
          "<=450 msec",
          ">450 to <=480 msec",
          ">480 to <= 500 msec",
          ">500 msec",
          "<Missing>"
        )
      ),
      CHGCAT1 = factor(
        CHGCAT1,
        levels = c(
          "<=30 msec",
          ">30 to <=60 msec",
          ">60 msec",
          "<Missing>"
        )
      )
    )
  col_labels(ADEG) <- c(
    adeg_labels,
    "AVALCAT1" = "Value at Visit",
    "CHGCAT1" = "Change from Baseline"
  )
})
datanames <- c("ADSL", "ADEG")
datanames(data) <- datanames
join_keys(data) <- default_cdisc_join_keys[datanames]

## Reusable Configuration For Modules
ADSL <- data[["ADSL"]]
ADEG <- data[["ADEG"]]

## Setup App
app <- init(
  data = data,
  modules = modules(
    tm_t_summary_by(
      label = "ECG Actual Values and Changes from Baseline by Visit",
      dataname = "ADEG",
      arm_var = choices_selected(
        choices = variable_choices(ADSL, c("ARM", "ARMCD")),
        selected = "ARM"
      ),
      by_vars = choices_selected(
        choices = variable_choices(ADEG, c("PARAM", "AVISIT")),
        selected = c("AVISIT")
      ),
      summarize_vars = choices_selected(
        choices = variable_choices(ADEG, c("AVALCAT1", "CHGCAT1")),
        selected = c("AVALCAT1", "CHGCAT1")
      ),
      useNA = "ifany",
      paramcd = choices_selected(
        choices = value_choices(ADEG, "PARAMCD", "PARAM"),
        selected = "QT"
      )
    )
  )
)

shinyApp(app$ui, app$server)

Reproducibility

Timestamp

[1] "2025-07-09 17:47:01 UTC"

Session Info

─ Session info ───────────────────────────────────────────────────────────────
 setting  value
 version  R version 4.5.0 (2025-04-11)
 os       Ubuntu 24.04.2 LTS
 system   x86_64, linux-gnu
 ui       X11
 language (EN)
 collate  en_US.UTF-8
 ctype    en_US.UTF-8
 tz       Etc/UTC
 date     2025-07-09
 pandoc   3.7.0.2 @ /usr/bin/ (via rmarkdown)
 quarto   1.7.32 @ /usr/local/bin/quarto

─ Packages ───────────────────────────────────────────────────────────────────
 package               * version  date (UTC) lib source
 backports               1.5.0    2024-05-23 [1] RSPM
 brio                    1.1.5    2024-04-24 [1] RSPM
 broom                   1.0.8    2025-03-28 [1] RSPM
 bslib                   0.9.0    2025-01-30 [1] RSPM
 cachem                  1.1.0    2024-05-16 [1] RSPM
 callr                   3.7.6    2024-03-25 [1] RSPM
 checkmate               2.3.2    2024-07-29 [1] RSPM
 chromote                0.5.1    2025-04-24 [1] RSPM
 cli                     3.6.5    2025-04-23 [1] RSPM
 coda                    0.19-4.1 2024-01-31 [1] CRAN (R 4.5.0)
 codetools               0.2-20   2024-03-31 [2] CRAN (R 4.5.0)
 curl                    6.4.0    2025-06-22 [1] RSPM
 dichromat               2.0-0.1  2022-05-02 [1] CRAN (R 4.5.0)
 digest                  0.6.37   2024-08-19 [1] RSPM
 dplyr                 * 1.1.4    2023-11-17 [1] RSPM
 emmeans                 1.11.1   2025-05-04 [1] RSPM
 estimability            1.5.1    2024-05-12 [1] RSPM
 evaluate                1.0.4    2025-06-18 [1] RSPM
 farver                  2.1.2    2024-05-13 [1] RSPM
 fastmap                 1.2.0    2024-05-15 [1] RSPM
 fontawesome             0.5.3    2024-11-16 [1] RSPM
 forcats                 1.0.0    2023-01-29 [1] RSPM
 formatR                 1.14     2023-01-17 [1] CRAN (R 4.5.0)
 formatters            * 0.5.11   2025-04-09 [1] RSPM
 geepack                 1.3.12   2024-09-23 [1] RSPM
 generics                0.1.4    2025-05-09 [1] RSPM
 ggplot2                 3.5.2    2025-04-09 [1] RSPM
 glue                    1.8.0    2024-09-30 [1] RSPM
 gtable                  0.3.6    2024-10-25 [1] RSPM
 htmltools               0.5.8.1  2024-04-04 [1] RSPM
 htmlwidgets             1.6.4    2023-12-06 [1] RSPM
 httpuv                  1.6.16   2025-04-16 [1] RSPM
 jquerylib               0.1.4    2021-04-26 [1] RSPM
 jsonlite                2.0.0    2025-03-27 [1] RSPM
 knitr                   1.50     2025-03-16 [1] RSPM
 later                   1.4.2    2025-04-08 [1] RSPM
 lattice                 0.22-7   2025-04-02 [2] CRAN (R 4.5.0)
 lifecycle               1.0.4    2023-11-07 [1] RSPM
 logger                  0.4.0    2024-10-22 [1] RSPM
 magrittr              * 2.0.3    2022-03-30 [1] RSPM
 MASS                    7.3-65   2025-02-28 [2] CRAN (R 4.5.0)
 Matrix                  1.7-3    2025-03-11 [1] CRAN (R 4.5.0)
 memoise                 2.0.1    2021-11-26 [1] RSPM
 mime                    0.13     2025-03-17 [1] RSPM
 multcomp                1.4-28   2025-01-29 [1] RSPM
 mvtnorm                 1.3-3    2025-01-10 [1] RSPM
 nestcolor               0.1.3    2025-01-21 [1] RSPM
 nlme                    3.1-168  2025-03-31 [2] CRAN (R 4.5.0)
 pillar                  1.11.0   2025-07-04 [1] RSPM
 pkgcache                2.2.4    2025-05-26 [1] RSPM
 pkgconfig               2.0.3    2019-09-22 [1] RSPM
 processx                3.8.6    2025-02-21 [1] RSPM
 promises                1.3.3    2025-05-29 [1] RSPM
 ps                      1.9.1    2025-04-12 [1] RSPM
 purrr                   1.0.4    2025-02-05 [1] RSPM
 R6                      2.6.1    2025-02-15 [1] RSPM
 random.cdisc.data       0.3.16   2024-10-10 [1] RSPM
 rbibutils               2.3      2024-10-04 [1] RSPM
 RColorBrewer            1.1-3    2022-04-03 [1] RSPM
 Rcpp                    1.1.0    2025-07-02 [1] RSPM
 Rdpack                  2.6.4    2025-04-09 [1] RSPM
 rlang                   1.1.6    2025-04-11 [1] RSPM
 rmarkdown               2.29     2024-11-04 [1] RSPM
 rtables               * 0.6.13   2025-06-19 [1] RSPM
 sandwich                3.1-1    2024-09-15 [1] RSPM
 sass                    0.4.10   2025-04-11 [1] RSPM
 scales                  1.4.0    2025-04-24 [1] RSPM
 sessioninfo             1.2.3    2025-02-05 [1] any (@1.2.3)
 shiny                 * 1.11.1   2025-07-03 [1] RSPM
 shinycssloaders         1.1.0    2024-07-30 [1] RSPM
 shinyjs                 2.1.0    2021-12-23 [1] RSPM
 shinyvalidate           0.1.3    2023-10-04 [1] RSPM
 shinyWidgets            0.9.0    2025-02-21 [1] RSPM
 stringi                 1.8.7    2025-03-27 [1] RSPM
 stringr                 1.5.1    2023-11-14 [1] RSPM
 survival                3.8-3    2024-12-17 [2] CRAN (R 4.5.0)
 teal                  * 0.16.0   2025-02-23 [1] RSPM
 teal.code             * 0.6.1    2025-02-14 [1] RSPM
 teal.data             * 0.7.0    2025-01-28 [1] RSPM
 teal.logger             0.4.0    2025-07-08 [1] RSPM
 teal.modules.clinical * 0.10.0   2025-02-28 [1] RSPM
 teal.reporter           0.4.0    2025-01-24 [1] RSPM
 teal.slice            * 0.6.0    2025-02-03 [1] RSPM
 teal.transform        * 0.6.0    2025-02-12 [1] RSPM
 teal.widgets            0.4.3    2025-01-31 [1] RSPM
 tern                  * 0.9.9    2025-06-20 [1] RSPM
 tern.gee                0.1.5    2024-08-23 [1] RSPM
 testthat                3.2.3    2025-01-13 [1] RSPM
 TH.data                 1.1-3    2025-01-17 [1] RSPM
 tibble                  3.3.0    2025-06-08 [1] RSPM
 tidyr                   1.3.1    2024-01-24 [1] RSPM
 tidyselect              1.2.1    2024-03-11 [1] RSPM
 vctrs                   0.6.5    2023-12-01 [1] RSPM
 webshot                 0.5.5    2023-06-26 [1] CRAN (R 4.5.0)
 webshot2                0.1.2    2025-04-23 [1] RSPM
 websocket               1.4.4    2025-04-10 [1] RSPM
 withr                   3.0.2    2024-10-28 [1] RSPM
 xfun                    0.52     2025-04-02 [1] RSPM
 xtable                  1.8-4    2019-04-21 [1] RSPM
 yaml                    2.3.10   2024-07-26 [1] RSPM
 zoo                     1.8-14   2025-04-10 [1] RSPM

 [1] /usr/local/lib/R/site-library
 [2] /usr/local/lib/R/library
 [3] /github/home/R/x86_64-pc-linux-gnu-library/4.5
 * ── Packages attached to the search path.

──────────────────────────────────────────────────────────────────────────────

.lock file

Download the .lock file and use renv::restore() on it to recreate environment used to generate this website.

Download