I think there was a slight misunderstanding of the expression. I checked online and this seems to work:
35.74 + (0.6215 * Temp) - (35.75 * pow(Wind, 0.16)) + (0.4275 * Temp * pow(Wind, 0.16)) as [Wind Chill];
LOAD * INLINE [
249394.qvw 150.2 K
so that worked perfectly. and then i ran into another problem. it turns out there is a point at which the wind chill is replaced with the heat index. the logic is if the temp is greater than 80 and relative humidity is greater than 40%, then use heat index for apparent temp, else use windchill for apparent temp.
so what i would like to do is figure out how to have individual windchill (solved) and heat index variables, as well as an apparent temp variable that factors the logic.
heat index formula below (wikipedia entry). you have been SO helpful, and i appreciate anything else youre willing to help with.
i have temp in the model as well as humidity (CmpHumidity)
The expression in QlikView should be like this:
(2.04901523 * Temp) +
(10.14333127 * CmpHumidity) +
(-0.22475541 * Temp * CmpHumidity) +
(-683783 * pow(10,-3) * pow(Temp, 2)) +
(-5.481717 * pow(10, -2) * pow(CmpHumidity, 2)) +
(1.22874 * pow(10, -3) * pow(Temp, 2) * CmpHumidity) +
(8.5282 * pow(10, -4) * Temp * pow(CmpHumidity, 2)) +
(-1.99 * pow(10, -6) * pow(Temp, 2) * pow(CmpHumidity, 2))
Not sure how this is related to Wind Chill... Can you elaborate on that part?