topic Re: Need help for scatter chart in QlikView

Need help for scatter chart

sweety0912 — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I need help for x-axis on dot chart. Hours is a measure(Y-Axis) and using row number as dimension(X-axis). I have few filters(list boxes) left side which is region, Date and group etc.

Expressions that i am using is --- Sum(RowNumber) and Sum(Hours)

Dimension is Rownumber.

If i select any filter from left side X-axis should start with Zero. For example if i select Region="AP" row number should start with 0 or 1 to 1000( End of that range). If i select group ="A" again X axis should start with "0" or "1" to the end of row number.Basically what i am expecting is for any filter the row number(X-axis) should start with Zero to end of the Number.Basically row number will give you the sequence of number but what i want is for any filter if i select row number should start with "0" or "1".

Can you please help me on this!

Please let me know if you don't understand my question!

Re: Need help for scatter chart

sweety0912 — Fri, 06 Jul 2018 13:11:30 GMT

Can anyone respond to this? Please let me know if you don't understand my question.

Thanks!

Re: Need help for scatter chart

ogautier62 — Fri, 06 Jul 2018 13:49:39 GMT

may be an idea if I've well understood

in dimension :

valueloop(1,count(total hours))

in expression :

fractile(hours,1/(count(total hours) - 1)*(valueloop(1,count(total hours))-1))

not very "pretty" but dimension allways 1 to nb od rows

regards

Re: Need help for scatter chart

sweety0912 — Fri, 06 Jul 2018 16:21:20 GMT

I have tried the formula but it is not working.

Please find the attached Qvw. If i select region='EU' you see the data Rowno() 1,3,5..etc. But what i want is for any filter, Rowno() should be sequential.like 1,2,3..etc. Need to override the initial rowno() assigned by qlikview.

Please help me on this?

Re: Need help for scatter chart

ogautier62 — Fri, 06 Jul 2018 18:14:45 GMT

do not use rowno()

it works for me,

another idea :

in dimension :H
=valueloop(1,count(Hours))

in expression :

subfield(concat(total aggr(Hours,Hours),'*'),'*',valueloop(1,count(Hours)))

it works on my sample, can't upload your qvw I've free version

regards

Re: Need help for scatter chart

Anonymous — Fri, 23 Nov 2018 04:30:08 GMT

Hi, were you able to get this to work? Can you share your qvw?