Discussion Board for collaboration related to QlikView App Development.
Like Excel can take the largest value of a column range and use it to calculate a metric, I am looking to do this in Qlikview. I have been messing around with some ColumnNum & Max functions, but I can't seem to get it. The current expression1 is a sum(field1) which gives me their total dollars lets say... I am trying to create an expression to take that and divided by the person with the largest sum. This will give me their "percent to best". Maybe an expression that looks at that column/cell to the left and divides by the biggest number in that column?
I have provided a sample screenshot of what I am looking for. Any ideas?
Accepted Solutions
Try like using straight table
Add straight table with
Dim: Dimension
Expressions:
= Sum(Expression1)
= Num(Sum(Expr)/max(TOTAL Expr), '#,##0.00')*100 & '%'
you can set the %ge in Number tab of the chart properties like below
Try like using straight table
Add straight table with
Dim: Dimension
Expressions:
= Sum(Expression1)
= Num(Sum(Expr)/max(TOTAL Expr), '#,##0.00')*100 & '%'
you can set the %ge in Number tab of the chart properties like below
