Dimension into measure

[thewillemzelluf]

Dear people,

I have a problem with the weather data from Qlik. If I want to use the temperature as a measurement, then I get 0 values while they are displayed properly if I use them as a dimension. Someone any idea how this can and what I have to change to use the weather as a measurement?

Gr, Willem

[agigliotti]

could you share temp values?

[timpoismans]

Hi Willem

The fields you are trying to use calculations are text fields (Or at least the one you are trying to use).

If you'd use the following in the script:

Evaluate("Average of the 24 hourly feels like temperature values in degrees Celsius") AS [Average of the 24 ...]

You should be able to use the sum function.

[timpoismans]

Using Evaluate() in script converted the text to num.

The temp values are pulled from the free section of the Qlik Data Market