topic Set analysis - Valuelist Issue in App Development

Set analysis - Valuelist Issue

Milaf — Wed, 14 Feb 2024 21:17:58 GMT

Hello everyone,

The set analysis I applied does not work with the valulist formula. Is there a different solution? My chart should not be affected by my date filters.

if(ValueList ('P', 'PD')= 'PD, sum( {<[BFlag]={"0"},Month= ,YearMonth=, Year=, DAY= >} FCount),
if(ValueList ('P', 'PD') = 'P', SUM({<[Owner]={'PAEW','OUT'},[BFlag]={"0"}, YearMonth=,Month=,Year=,DAY= >}FCount)))

Thank you.

Re: Set analysis - Valuelist Issue

anat — Thu, 15 Feb 2024 02:44:58 GMT

can you try using pick and match

pick(match(ValueList ('P', 'PD'),'P','PD'),sum(sal),sum(cost))

Re: Set analysis - Valuelist Issue

Milaf — Thu, 15 Feb 2024 05:44:48 GMT

Hi, than you for response.

I changed the formula according to the format below, I got syntax ok but my chart is not created. I use Barchart, the pick formula does not seem to be suitable.

pick(Match(ValueList ('P', 'PD')= 'PD', 'P', sum( {<[BFlag]={"0"},Month= ,YearMonth=, Year=, DAY= >} FCount), SUM({<[Owner]={'PAEW','OUT'},[BFlag]={"0"}, YearMonth=,Month=,Year=,DAY= >}FCount))

Re: Set analysis - Valuelist Issue

anat — Thu, 15 Feb 2024 12:22:27 GMT

Can you try below one

pick(Match(ValueList ('P', 'PD'), 'PD', 'P') ,sum( {<[BFlag]={"0"},Month= ,YearMonth=, Year=, DAY= >} FCount), SUM({<[Owner]={'PAEW','OUT'},[BFlag]={"0"}, YearMonth=,Month=,Year=,DAY= >}FCount))

Re: Set analysis - Valuelist Issue

Milaf — Thu, 15 Feb 2024 13:54:22 GMT

Still affected by my YearMonth filter 😞 Interestingly it is not affected by my DAY filter, it works correctly. I must be missing something.

Re: Set analysis - Valuelist Issue

anat — Thu, 15 Feb 2024 13:59:34 GMT

in set analysis all time filters are bypassed,if want to filter the data based on time filters remove from set analysis

pick(Match(ValueList ('P', 'PD'), 'PD', 'P') ,sum( {<[BFlag]={"0"},Month= ,YearMonth=, Year=, DAY= >} FCount), SUM({<[Owner]={'PAEW','OUT'},[BFlag]={"0"}, YearMonth=,Month=,Year=,DAY= >}FCount))

to affect DAY filter use below expression

pick(Match(ValueList ('P', 'PD'), 'PD', 'P') ,sum( {<[BFlag]={"0"},Month= ,YearMonth=, Year= >} FCount), SUM({<[Owner]={'PAEW','OUT'},[BFlag]={"0"}, YearMonth=,Month=,Year= >}FCount))

Re: Set analysis - Valuelist Issue

Milaf — Thu, 15 Feb 2024 17:28:19 GMT

I think my formula is correct because I am showing 12 months (yearly) in my chart and I don't want it to be affected by any time expression (filters) in my report. Always show 12 months. For this reason, I added my set expressions.

Re: Set analysis - Valuelist Issue

Oleg_Troyansky — Thu, 15 Feb 2024 18:38:17 GMT

Hi Milaf,

The problem is certainly not related to the ValueList() function. I'd guess that you are using a different field for your YearMonth filter, not the same field as listed in your Set Analysis formula. Double check your filters.

Cheers,