Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

danm84306
New Contributor III

Count If

Hello, I am trying to complete this calculation only counting data where the Location Column reads 'Remote'. Any ideas?

Sum(if(Type='T',[Time (Min)])/60/24)+Sum(if(Type='NT',[Time (Min)])/60/24))

/

((((
Count(Distinct Date&Name))*480)/60/24)-Sum(if(Type='P',[Time (Min)])/60/24)-(((Count(Distinct Date&Name)-Sum(if(Type='P',Quantity)))*30)/60/24))

3 Replies

Re: Count If

May be this:

Sum({<Location = {'Remote'}>} if(Type='T',[Time (Min)])/60/24) + Sum({<Location = {'Remote'}>} if(Type='NT',[Time (Min)])/60/24))

/

((((Count({<Location = {'Remote'}>} Distinct Date&Name))*480)/60/24)-Sum({<Location = {'Remote'}>} if(Type='P',[Time (Min)])/60/24)-(((Count({<Location = {'Remote'}>} Distinct Date&Name)-Sum({<Location = {'Remote'}>} if(Type='P',Quantity
)))*30)/60/24))

Highlighted

Re: Count If

Hi,

try every expression in set analysis.

Sum({<Location = {'Remote'},Type={'T','NT'}>}[Time (Min)])/60/24

/

(
(
  (
   (
    Count({<Location = {'Remote'}>} Distinct Date&Name)
   )*480
  )/60/24
)
-
Sum({<Location = {'Remote'},Type={'P'}>}[Time (Min)])/60/24
-
(
  (
   (
    Count({<Location = {'Remote'}>} Distinct Date&Name)
    -
    Sum({<Location = {'Remote'},Type={'P'}>} Quantity)
   )*30
  )/60/24
)
)

Regards

Great dreamer's dreams never fulfilled, they are always transcended.

Re: Count If

=((Sum({<Type{'T'}>}[Time (Min)])/60/24)+(Sum({<Type{'NT'}>}[Time (Min)])/60/24))

/

(((Count(Distinct Date&Name)*480)/60/24)-(Sum({<Type={'P'}>}[Time (Min)])/60/24)-(((Count(Distinct Date&Name)-Sum({<Type={'P'}>}Quantity))*30)/60/24))