Need help for scatter chart

[sweety0912]

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!

[sweety0912]

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

Thanks!

[ogautier62]

Hi

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

[sweety0912]

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?

[ogautier62 · Accepted solution]

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

[Anonymous]

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