Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
can you try using pick and match
pick(match(ValueList ('P', 'PD'),'P','PD'),sum(sal),sum(cost))
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))
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))
Still affected by my YearMonth filter 😞 Interestingly it is not affected by my DAY filter, it works correctly. I must be missing something.
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))
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.
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,