3 Replies Latest reply: Oct 23, 2018 4:02 AM by youssef belloum RSS

    Scatter plot

    Helge Jørgensen

      Dear, Qlik experts

       

      I’m trying to create a scatter plot, but it does not look right. I think that my problem is related to data registration.

       

      One measure is registered at all dates, in a range from 0 – 30. The second measurement is only registered at dates when it occurs. Meaning that there is a lot of dates without measurements/registrations. The measurements are from two different sources, connected through date.

       

      Is there an expression I can use that will give the days without a registration a value of 0, so that all dates will have a registration?


      These are the measurement used in the scatter plot:

      Avg({$<ElementID = {'HA'}>} [Value])

      Count(CustID)

      The dimension used is dates

       

      Cheers,

      Helge