Set analysis count

[venkatg6759]

Hello Everybody,

I have the following expression

Only( {$<[Review Area Name]={'Overall'},[Product Group]={'All Products'}>},[Client Name])

I want to include if(Count([Review Area General Comments]>1 in the above expression

I tried something like this

Only( {$<[Review Area Name]={'Overall'},[Product Group]={'All Products'},[Review Area General Comments]={"=count([Review Area General Comments]>1"}>}[Client Name])

which is not giving me the result that is required .

Help me how to include this in the set analysis expression

Thanks,

Venkata

[Nicole-Smith]

Maybe like:

Only({$<[Review Area Name]={'Overall'},[Product Group]={'All Products'},[Client Name]={"=count([Review Area General Comments])>1"}>} [Client Name])

[venkatg6759]

Nope its not working .

Actually i need Client name

if ( Review Area Name = ' Overall' And Product Group = 'All Products' And count(Review Area General Comments>1),

Client Name

this is the entire logic that needs to be built .where if there are comments >1,and those conditions satisfy then client name should be the result .

[MK_QSL]

=Only({<[Review Area Name] = {'Overall'}, [Product Group] = {'All Products'}>}IF(Aggr(COUNT([Review Area General Comments])>1,[Client Name]),[Client Name]))

In case if you have more than one Client Name satisfying your condition... you can use...

=Concat({<[Review Area Name] = {'Overall'}, [Product Group] = {'All Products'}>}IF(Aggr(COUNT([Review Area General Comments])>1,[Client Name]),[Client Name]),', ')

Set Analysis

=Concat({<[Review Area Name] = {'Overall'}, [Product Group] = {'All Products'}, [Client Name] = {"=Aggr(COUNT([Review Area General Comments]),[Client Name])>1"}>} DISTINCT [Client Name],', ')

or

=Only({<[Review Area Name] = {'Overall'}, [Product Group] = {'All Products'}, [Client Name] = {"=Aggr(COUNT([Review Area General Comments]),[Client Name])>1"}>} DISTINCT [Client Name])

[venkatg6759]

The comments should not be blank and if comments have count which is greater than 1 than client should appear

[MK_QSL]

This is what I have written. are my codes not working?