- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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!
- « Previous Replies
-
- 1
- 2
- Next Replies »
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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])
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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])
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Andrew,
Thanks but it is not very clear to me...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Sunny,
I can't use sum because the field Ship Out Performance on time is expressed in percentages.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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])
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Yes there are multiple values for Ship Out Performance on time per dimension so using sum would not help
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
This would not help as each row would have to be multiplied with different value of ship out performance on time.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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]))
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
No, this does not work.
- « Previous Replies
-
- 1
- 2
- Next Replies »