set analysis

[vipin_mishra479]

i have a three field empname, year, permossion and i want a name of emp whose permossion flag is false for all three year.

[CELAMBARASAN]

Try this

Concat({<permossion={'false'}>} empname, ',')

[vipin_mishra479]

i want a emp name whose permossion flag is false for all three year

[CELAMBARASAN · Accepted solution]

try the exp below.

Concat(Aggr(If(Count(Distinct {<permossion={'false'}>} year)>2,empname), empname), ',')

i didn't checked the result of it