topic Re: set analysis in QlikView

set analysis

vipin_mishra479 — Thu, 19 Jul 2012 12:50:31 GMT

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 — Thu, 19 Jul 2012 13:08:36 GMT

Try this

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

vipin_mishra479 — Thu, 19 Jul 2012 13:27:52 GMT

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

CELAMBARASAN — Thu, 19 Jul 2012 13:34:03 GMT

try the exp below.

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

i didn't checked the result of it