topic Re: RangeSum with ValueList() in App Development

RangeSum with ValueList()

silviacico — Wed, 27 Apr 2016 13:34:32 GMT

Hello everybody,

I'm having some problems with the function ValueList() with a RangeSum(above(...)), in particular I'm using the ValueList in order to set colors in my bar chart.

The code is:

if(ValueList('New usersi','Existing users', 'Inactive')='New users'

,(count({$<result={'ok'}, flag={'Battesimo'}>} DISTINCT user_id2))

,if(ValueList('New users','Existing users', 'Inactive')='Existing users'

,(count({$<result={'ok'}, flag={'Totale giocate'}>} DISTINCT user_id2))- count({$<result={'ok'}, flag={'Battesimo'}>} DISTINCT user_id2)

,if (ValueList('New users','Existing users', 'Inactive')= 'Inactive'

,(rangesum(above(count({$<result={'ok'}, flag={'Battesimo'}>} DISTINCT user_id2),1,rowno()-1) )

- (

count({$<result={'ok'}, flag={'Totale giocate'}>} DISTINCT user_id2)

count({$<result={'ok'}, flag={'Battesimo'}>} DISTINCT user_id2)

)

With dimensions:

- Weekstart(link_date)

- ValueList('New users','Existing users', 'Inactive').

I tried the code without the ValueList (using 3 different measures and only "Weekstart(link_date)" as dimension) and it's working, however with the valuelist the measure in the third IF is not working.

Thank you

Re: RangeSum with ValueList()

swuehl — Wed, 27 Apr 2016 16:07:31 GMT

Not exactely sure what you want to calculate.

But remember that Above() is limited to the column segment (without using TOTAL), so not sure how this is supposed to work given the ValueList() not really linked to your data model, thus returning the same record set for each dimensional value.

If you can post a small sample QVW and your expected results, maybe this helps to understand your issue.

Re: RangeSum with ValueList()

silviacico — Thu, 28 Apr 2016 10:17:35 GMT

Hi swuehl,

that's an example of my problem, the second graph has to look like the first one, but the ValueList creates the issue.

Thanks,

Silvia