I'm trying to create a pie chart.
The data for the pie chart consists of 1 record with 2 fields.
These 2 fields (total patients (109) and patients reviewed (40)) should create the pie chart.
I use this for the calculation in Slice data:
~QryRes = ExecuteSQL ("SELECT GecorrigeerdePatienten, TotaalAfspraken
WHERE Arts_Code = ?" ; "¶" ; "" ; Dashboard::Arts01 );
~PieVal1 = GetValue ( ~QryRes; 1);
~PieVal2 = GetValue ( ~QryRes; 2);
~RetVal = List(~PieVal1;~PieVal2)
The result is this:
As you can see the 109 for total patients and 40 for the patients reviewed are found, but the data is seen as one big value and not as 2 separate values.
What am I doing wrong?