10 Replies Latest reply: Jan 1, 2018 11:43 AM by Martin Mahler RSS

    creating non aggregated graphs


      i have been using qlik quite some time now and a happy user. Qlik is very helpful in learning from historical data. What i want to do now is also show realtime data. we have sensors in the field at our customers and they produce very much data. I want to show this data to monitor the health of the sensors. So i have a timestamp when the data was collected from the sensor and have the diagnostic and process data at that timestamp. Now i want to show this in a graph without aggregating the data. So lets say the timestamp on the x-as and the measured values on the y-ax. But the only option that i have is to count, sum, average etc.

      That is not what i need. I need to visualise the data that is measured without aggregation. Can someone help me?

        • Re: creating non aggregated graphs
          balraj ahlawat

          dont use any aggregate function like Count, sum, avg()...


          Simply use measure field as a expression.


          Say, Amount is your measure then don't use sum(Amount), simply take Amount as a expression

            • Re: creating non aggregated graphs
              Martin Mahler

              This is not entirely correct. If you use your measure as a field expression Qlik will implicitly use the only function and return distinct values. Hence, if a dimension has multiple measures of the same value, it will only be returned once. If you truly want to see values in a chart/table on its most granular level you will need to create a RowId() field in the script and use this as your dimension/measure.

            • Re: creating non aggregated graphs
              Sangram Reddy

              Hi Eelco van,


              You can use any measure field with out aggregating it as a measure. Just make sure its a measure. That's It!

              • Re: creating non aggregated graphs
                Jonathan Poole

                I agree with martin,  qlik visualizations typically represent some sort of aggregation. You can avoid that by introducing a unique key (different value for each row of data) and then including that key in the chart.   Only() and concat() functions will render those values without doing a sum or max etc...    The key again is to be including a dimension that is unique across the measure values. 


                If you had an example visual of what you want to show (like if you have 2 measure values for 1 dimension value) and how you'd like to visualize it , that would help make suggestions.

                • Re: creating non aggregated graphs

                  Hi Guy's


                  thnx all very much for your supplies, @martin and Jonathan you guy's understand what i mean. However i'm having difficulties creating this my self. So have taken some sample of the raw data and included that.

                  What i would like to have in a graph on the horizontal axis is the time stamp and on the vertical axis the three remaining collums. Could you give me the code on how to load this in qlik so that i can create this graph?


                  thnx in advance!