topic Re: Count Help in QlikView

Count Help

Anonymous — Tue, 25 Nov 2014 10:54:53 GMT

Hi All,

I am having a following fields ,Service Name, Application name . And I need to find out which service having more than 2 Applications.

I have used Count(if(Applicationname)>2,Applicationname)

also

Count({<Applicationame={<'>2'>}>}Applicationname)

Kindly share your thoughts

-Jay

anbu1984 — Tue, 25 Nov 2014 10:58:28 GMT

If(Aggr(Count([Application name]),[Service Name])>2,Count([Application name]))

Gysbert_Wassenaar — Tue, 25 Nov 2014 10:59:55 GMT

Create a straight table

Use Service Name as dimension

Use as expression =count({<[Service Name]={'=count([Application name])>2'}>} [Application name])

PrashantSangle — Tue, 25 Nov 2014 11:01:24 GMT

Hi,

Try like,

Count(if(count(Aggr(ApplicationName,ServiceName))>2,ServiceName))

Regards

Anonymous — Tue, 25 Nov 2014 11:08:06 GMT

if (aggr(count(AppName),ServiceName)>1,ServiceName)