topic Re: Set analysis count in QlikView

Set analysis count

venkatg6759 — Wed, 09 Apr 2014 18:19:50 GMT

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

Re: Set analysis count

Nicole-Smith — Wed, 09 Apr 2014 18:23:52 GMT

Maybe like:

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

Re: Set analysis count

venkatg6759 — Wed, 09 Apr 2014 18:36:47 GMT

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 .

Re: Set analysis count

MK_QSL — Wed, 09 Apr 2014 19:05:07 GMT

=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],', ')

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

Re: Set analysis count

venkatg6759 — Wed, 09 Apr 2014 19:24:11 GMT

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

Re: Set analysis count

MK_QSL — Wed, 09 Apr 2014 19:30:25 GMT

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