Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
thewillemzelluf
Creator
Creator

Dimension into measure

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?

dimension measure.png

Gr, Willem

12 Replies
timpoismans
Specialist
Specialist

Might just be the formatting of your measure:

(Sorry for the Dutch terms)

Dim_to_Measure.PNG

If you change the "Getalnotatie" from 'Automatic' to 'Number', you should be able to see the values correctly.

agigliotti
Partner - Champion
Partner - Champion

why do you need to use temp as measure ?

thewillemzelluf
Creator
Creator
Author

okay this is unfortunately not the solution, He continues to give 0 values.

thewillemzelluf
Creator
Creator
Author

to aggregate it and to use it in graphs

timpoismans
Specialist
Specialist

Any chance you could give us a sample qvf? Always easier to check things than guessing what could be wrong.

thewillemzelluf
Creator
Creator
Author

Sorry i dont know how to share an app from Qlik sense enterprise but here you have the script.

Data:

LOAD

    qlik_datamarket_52kv._dim_8vq5,

    "Date",

    "Average of the 24 hourly cloud cover observations as a percentage",

    "Average of the 24 hourly dew point observations in degrees Celsius",

    "Average of the 24 hourly dew point observations in degrees Fahrenheit",

    "Average of the 24 hourly feels like temperature values in degrees Celsius",

    "Average of the 24 hourly feels like temperature values in degrees Fahrenheit",

    "Average of the 24 hourly relative humidity values  as a percentage",

    "Average of the 24 hourly station pressure observations  in millibars",

    "Average of the 24 hourly temperature observations in degrees Celsius",

    "Average of the 24 hourly temperature observations in degrees Fahrenheit",

    "Average of the 24 hourly wetbulb values in degrees Celsius",

    "Average of the 24 hourly wetbulb values in degrees Fahrenheit",

    "Average of the 24 hourly wind speed observations  in km per hour",

    "Average of the 24 hourly wind speed observations  in miles per hour",

    "Average of the daily minimum and maximum temperatures in Celsius",

    "Average of the daily minimum and maximum temperatures in Fahrenheit",

    "Cooling degree day value from daily average temperature in Fahrenheit",

    "Cooling degree day value from daily average temperature in degrees Celsius",

    "Daily total precipitation (rainfall and/or melted amount of snow) in cm",

    "Daily total precipitation (rainfall and/or melted amount of snow) in inches",

    "Daily total snowfall in cm",

    "Daily total snowfall in inches",

    "Heating degree day value from daily average temperature in Fahrenheit",

    "Heating degree day value from daily average temperature in degrees Celsius",

    "Maximum daily temperature in degrees Celsius",

    "Maximum daily temperature in degrees Fahrenheit",

    "Maximum of the 24 hourly cloud cover observations as a percentage",

    "Maximum of the 24 hourly dew point observations in degrees Celsius",

    "Maximum of the 24 hourly dew point observations in degrees Fahrenheit",

    "Maximum of the 24 hourly feels like temperature values in degrees Celsius",

    "Maximum of the 24 hourly feels like temperature values in degrees Fahrenheit",

    "Maximum of the 24 hourly relative humidity values  as a percentage",

    "Maximum of the 24 hourly station pressure observations  in millibars",

    "Maximum of the 24 hourly wetbulb values in degrees Celsius",

    "Maximum of the 24 hourly wetbulb values in degrees Fahrenheit",

    "Maximum of the 24 hourly wind speed observations  in km per hour",

    "Maximum of the 24 hourly wind speed observations  in miles per hour",

    "Minimum daily temperature in degrees Celsius",

    "Minimum daily temperature in degrees Fahrenheit",

    "Minimum of the 24 hourly cloud cover observations as a percentage",

    "Minimum of the 24 hourly dew point observations in degrees Celsius",

    "Minimum of the 24 hourly dew point observations in degrees Fahrenheit",

    "Minimum of the 24 hourly feels like temperature values in degrees Celsius",

    "Minimum of the 24 hourly feels like temperature values in degrees Fahrenheit",

    "Minimum of the 24 hourly relative humidity values  as a percentage",

    "Minimum of the 24 hourly station pressure observations in millibars",

    "Minimum of the 24 hourly wetbulb values in degrees Celsius",

    "Minimum of the 24 hourly wetbulb values in degrees Fahrenheit",

    "Minimum of the 24 hourly wind speed observations in km per hour",

    "Minimum of the 24 hourly wind speed observations in miles per hour"

FROM [lib://QlikView_Content_vdPlas (heembloemex_qliksensebeheer)/Production\Data\QVD\Source_Weather\Weather_Data_50_Cities.qvd]

(qvd);

Locations:

LOAD

    qlik_datamarket_52kv._dim_8vq5,

    Country,

    City,

    "ICAO airport code",

    "ISO 3166",

    Latitude,

    Longitude,

    "Numeric time zone",

    "Olson time zone",

    "WMO station identifier"

FROM [lib://QlikView_Content_vdPlas (heembloemex_qliksensebeheer)/Production\Data\QVD\Source_Weather\Location.qvd]

(qvd);

timpoismans
Specialist
Specialist

Script won't help much as it's loading data from a connection I don't have

Should be able to export applications from Qlik Sense Enterprise.

Trying to get the data from Data Market right now, will let you now if I can reproduce the issue.

agigliotti
Partner - Champion
Partner - Champion

could you attach a printscreen adding temp as dimension ?

are you sure temp field type is number ?

timpoismans
Specialist
Specialist

I just checked and as far as I can tell, the temp field is not a number.

But conversion using Num#() returns the value without converting the type.

Conversion using Num() returns Null-values.