topic Re: Substitute a variable into an expression in QlikView

Substitute a variable into an expression

jimgibson — Wed, 25 Nov 2020 16:16:04 GMT

In what I have below, how do I substitute the value of vCHMetricToUse into eCHMetricEncounterCNT and eCHMetricMedian ?

Set vCHMetricToUse=A-AD;
Set eCHMetricEncounterCNT= Count([PatientEncounterID]) - NullCount([A-AD]);
Set eCHMetricMedian=Median([A-AD]);
Set vCHMetric=Door to Admit Throughput;

Thanks in Advance

Re: Substitute a variable into an expression

sunny_talwar — Mon, 06 Jun 2016 19:41:44 GMT

May be this:

Set vCHMetricToUse=A-AD;
Set eCHMetricEncounterCNT= Count([PatientEncounterID]) - NullCount(vCHMetricToUse);
Set eCHMetricMedian=Median(vCHMetricToUse);
Set vCHMetric=Door to Admit Throughput;

Re: Substitute a variable into an expression

jimgibson — Mon, 06 Jun 2016 20:04:07 GMT

That did not work or at least when I tried to use it by setting the text in a text object as = $(eCHMetricMedian) I get nothing.

Re: Substitute a variable into an expression

swuehl — Mon, 06 Jun 2016 20:50:08 GMT

If you want the replacement to happen when the script executes, you can use a dollar sign expansion:

Set vCHMetricToUse=A-AD;

Set eCHMetricEncounterCNT= Count([PatientEncounterID]) - NullCount([$(vCHMetricToUse)]);

Set eCHMetricMedian=Median([$(vCHMetricToUse)]);

Set vCHMetric=Door to Admit Throughput;

If you need the replacement to happen in the front end (i.e. you want to change vCHMetricToUse also in the front end, try

Set vCHMetricToUse=A-AD;

LET eCHMetricEncounterCNT= 'Count([PatientEncounterID]) - NullCount([$' & '(vCHMetricToUse)])';

LET eCHMetricMedian='Median([' & '$(vCHMetricToUse)])';

Set vCHMetric=Door to Admit Throughput;

Set vCHMetricToUse=A-AD;

LET eCHMetricEncounterCNT= Replace('Count([PatientEncounterID]) - NullCount([@(vCHMetricToUse)])','@','$');

LET eCHMetricMedian= Replace('Median([@(vCHMetricToUse)])','@','$');

Set vCHMetric=Door to Admit Throughput;

The Magic of Dollar Expansions

The Magic of Variables

Stop Dollar Sign Expansion in the script (Escape Character ??? )