Announcements
cancel
Showing results for
Did you mean:
Contributor III

## Set analysis - Valuelist Issue

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.

Labels (1)
• ### General Question

7 Replies
Master

can you try using pick and match

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

Contributor III
Author

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

Master

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

Contributor III
Author

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

Master

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

Contributor III
Author

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.