Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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
Can anyone respond to this? Please let me know if you don't understand my question.
Thanks!
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
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?
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
Hi, were you able to get this to work? Can you share your qvw?