topic Re: Total count in QlikView

Total count

Wed, 10 Feb 2016 13:00:22 GMT

Hi Experts,

i m working on employee dashboard.

i have the following table.

Table1:

Load Branch,

Jobtitle,

Empcode

from table.qvd(qvd);

Jobtitle has values like Manager, Director, Assistants, etc.

Empcode has Vacancy1, Vacancy2, Left, Poor Performance, etc

Now i have done a pivot table with branch & Jobtitle as dimension, Count(Empcode) as expression.

i need to calculate values which is not equal to zeros and filter particular Empcode.

So, i did the expression as:

if(COUNT(Empcode )<>0 and MATCH(Empcode,'Vacancy1','Vacancy2''),COUNT(Empcode),'')

it works fine. but the totals are giving nulls.

Please help me to correct the expression.

Re: Total count

sunny_talwar — Wed, 10 Feb 2016 13:05:47 GMT

Try adding Sum(Aggr()) around your expression with all the chart dimensions and see if that works.

Re: Total count

swuehl — Wed, 10 Feb 2016 13:06:16 GMT

Try

=Sum( Aggr(

if(COUNT(Empcode )<>0 and MATCH(Empcode,'Vacancy1','Vacancy2'), COUNT(Empcode)),

Branch, Jobtitle))

Re: Total count

sathishkumar_go — Wed, 10 Feb 2016 13:06:29 GMT

please post your application with sample data

-Sathish

Re: Total count

Wed, 10 Feb 2016 13:06:40 GMT

Hi,

Try this

COUNT({<Empcode -={0}>} Distinct Empcode)

Hope it helps!

Greetings,

Re: Total count

Wed, 10 Feb 2016 13:25:58 GMT

Swuehl, Sunny,

when i do sum(aggr()), it is giving total correctly but displaying zeros in some vacancies.

but the condition is COUNT(Empcode )<>0.

please help me

Re: Total count

swuehl — Wed, 10 Feb 2016 13:31:41 GMT

Maybe like this:

If(Dimensionality() = 0,

Sum( Aggr(

if(COUNT(Empcode )<>0 and MATCH(Empcode,'Vacancy1','Vacancy2'), COUNT(Empcode)),

Branch, Jobtitle))

if(COUNT(Empcode )<>0 and MATCH(Empcode,'Vacancy1','Vacancy2'), COUNT(Empcode),'')

)

I have the feeling there must be a better way to perform your count. Could you upload a small sample QVW?

Re: Total count

sasikanth — Wed, 10 Feb 2016 13:58:26 GMT

HI,

Try this

count(if(Aggr(Count(EmpCode),Branch, Jobtitle )<>0 and MATCH(Empcode,'Vacancy1','Vacancy2'),EmpCode))