Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Highlighted
Not applicable

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!

1 Solution

Accepted Solutions

Re: QlikView Expression to multiply count with a field

Average or Min or Max?

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

or

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

or

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

View solution in original post

10 Replies

Re: QlikView Expression to multiply count with a field

Not sure how your data is, but do you have multiple different values for Ship Out Performance on time per dimension? May be use Sum, Avg, Min, Max?

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

effinty2112
Honored Contributor

Re: QlikView Expression to multiply count with a field

Hello,

I think you can simplify your expression


=(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]


equals

=(count( {$<Success_Factor >}[Ticket #]) - count(  {$< Success_Factor ={'Success'} >}[Ticket #]))

/

count( {$<Success_Factor >}[Ticket #])* [Ship Out Performance on time]


equals


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


Cheers


Andrew

Not applicable

Re: QlikView Expression to multiply count with a field

Hi Andrew,

Thanks but it is not very clear to me...

Not applicable

Re: QlikView Expression to multiply count with a field

Hi Sunny,

I can't use sum because the field Ship Out Performance on time is expressed in percentages.

Re: QlikView Expression to multiply count with a field

Average or Min or Max?

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

or

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

or

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

View solution in original post

Not applicable

Re: QlikView Expression to multiply count with a field

Yes there are multiple values for Ship Out Performance on time per dimension so using sum would not help

Not applicable

Re: QlikView Expression to multiply count with a field

This would not help as each row would have to be multiplied with different value of ship out performance on time.

Re: QlikView Expression to multiply count with a field

How about this?

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

Not applicable

Re: QlikView Expression to multiply count with a field

No, this does not work.