The answer is plain and simple: you get the size of the pointer as result.
double *arrayValue;
sizeof(arrayValue);
To get the memory size of an array you must get the size of the element type (or one element) and multiply with its count. For example:
double array[40];
int arrSize1 = sizeof(double) * 40;
int arrSize2 = sizeof(array[0]) * 40;