Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
=Sum(aggr((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],YourDims))