Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
helge_jorg
Contributor

Scatter plot

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

Tags (2)
3 Replies
YoussefBelloum
Esteemed Contributor

Re: Scatter plot

Hi,

try this on your measures

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


Count(CustID)*sum(1)

helge_jorg
Contributor

Re: Scatter plot

Thanks for your suggestion, but it did not work with the sum before 1. The measurements ended up very stange and whey too large.


I did try to just multiply the measurements with 1 (without the sum). And it looks better.


Thanks for you help!

YoussefBelloum
Esteemed Contributor

Re: Scatter plot

Good