Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Highlighted
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))

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))