Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
vipin_mishra479
Contributor II

set analysis

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

1 Solution

Accepted Solutions

Re: set analysis

try the exp below.

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

i didn't checked the result of it

3 Replies

Re: set analysis

Try this

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

vipin_mishra479
Contributor II

Re: set analysis

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

Re: set analysis

try the exp below.

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

i didn't checked the result of it

Community Browser