Jump to content


Data Wizard

Data Wizard Filter Exclude Flag Span

  • Please log in to reply
2 replies to this topic

#1 spic



  • Members
  • Pip
  • 5 posts

Posted 10 April 2019 - 12:49 PM

Dear all,


I've been using the new version of Phoenix recently (Version 8.1) and I would like to use the new feature ot the NCA toolbox 'Rule'.

It's very easy and useful in this new version to be able to define some rules for NCA, for example to flag a value with R²<0.7. However, I would like to be able to exclude some other PK parameters associated to these conditions, for example to exclude half-life if R² and Lambda z were not appropriately determined. 


For example, from 'Final Paramters Pivoted' results in NCA tool, using 'Filter' in Data Wizard, I'm able to exclude 'AUC_%Extr_Obs' if value is higher than 20%, but in this case I would like to exclude also the AUCinf_obs value associated (for this subject only).


I didn't found how to deal with filter option to exclude one value associated to one rule in another column.


My goal will be to have a template that allows me to exclude PK parameters that do not comply with NCA rules from my analysis plan automatically (no manual selection).


Thanks greatly for your assistance. 

#2 Simon Davis

Simon Davis

    Advanced Member

  • Administrators
  • 1,232 posts

Posted 12 April 2019 - 10:36 AM

I would suggest to do it in two steps in the Data wizard.


first set a flag with an if statement  using a custom transformation.  You can have as many nested conditions as you want.


then after you have set all the flags  then you can filter those records by that flag in your last step.


Edited by Simon Davis, 12 April 2019 - 10:36 AM.

#3 Simon Davis

Simon Davis

    Advanced Member

  • Administrators
  • 1,232 posts

Posted 20 April 2022 - 10:23 AM

here's a nice video on nested IF statements; https://www.linkedin...4304647168-pLKZ

Also tagged with one or more of these keywords: Data Wizard, Filter, Exclude, Flag, Span

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users