Set analysis - Valuelist Issue

[Milaf]

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.

[anat]

can you try using pick and match

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

[Milaf]

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))

[anat]

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))

[Milaf]

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

[anat]

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))

[Milaf]

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.

[Oleg_Troyansky]

 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,