12 Replies Latest reply: Sep 19, 2018 5:54 AM by Tim Poismans RSS

    Dimension into measure

    willem van der Plas

      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

        • Re: Dimension into measure
          Tim Poismans

          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.

            • Re: Dimension into measure
              willem van der Plas

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

                • Re: Dimension into measure
                  Tim Poismans

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

                    • Re: Dimension into measure
                      willem van der Plas

                      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);

                        • Re: Dimension into measure
                          Tim Poismans

                          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.

                            • Re: Dimension into measure
                              Tim Poismans

                              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.


                              Dim_to_Measure2.PNG

                    • Re: Dimension into measure
                      Andrea Gigliotti

                      why do you need to use temp as measure ?