topic who is expert in set analysis in App Development

who is expert in set analysis

ali_hijazi — Mon, 17 Jun 2019 08:29:18 GMT

Hello I need an answer on set analysis syntax

I got a pivot table and 2 expressions
expression 1 is max({<man_days_type={"planned"}>} month_num)
expression 2 is sum({<month_num={">=$(fixed_start_month)"} man_days)

however in expression 2 I want to also include that month_num is <= to the value calculated in expression 1
kindly advise

Re: who is expert in set analysis

arpitkharkia — Mon, 17 Jun 2019 08:58:19 GMT

Create a variable and set the value as that of the first expression. Use the variable in the set analysis for the second expression.

Re: who is expert in set analysis

raman_rastogi — Mon, 17 Jun 2019 09:36:27 GMT

Try this
sum({<month_num={">=$(fixed_start_month) <=$(max({<man_days_type={"planned"}>} month_num))"} man_days)

Re: who is expert in set analysis

ali_hijazi — Mon, 17 Jun 2019 10:17:20 GMT

doesn't work as this requires a one value whereas the max value changes between values of the dimension

Re: who is expert in set analysis

ali_hijazi — Mon, 17 Jun 2019 11:50:38 GMT

the value is a table and not one value; it changes on rows; so doesn't work

Re: who is expert in set analysis

sunny_talwar — Mon, 17 Jun 2019 12:06:54 GMT

If this is based on row value, then set analysis is not going to work because set analysis is performed at a chart level and not at a row level. May be use Aggr() function with an if condition.