10 Replies Latest reply: Aug 16, 2016 7:49 AM by Manuel Capella RSS

    QlikView Expression to multiply count with a field

      Hello Friends,


      I have been calculating using a qlikview expression, however its a count function  in combination with a field .


      =(count( {$<Success_Factor >}[Ticket #]) - count(  {$< Success_Factor ={'Success'} >}[Ticket #]))/(count( {$<Success_Factor = {'Success'} >}[Ticket #]) +count( {$<Success_Factor >}[Ticket #]) - count( {$<Success_Factor = {'Success'} >}[Ticket #]))* [Ship Out Performance on time]


      I would like to multiply the first part of calculation with the  Ship Out Performance on time.


      I do get a null value because I do not know the correct way to calculate.

      Any clues to calculate this expression in the best possible way ?


      Many Thanks!