Maximum value

[Anonymous]

Hello,

in the column 6, i want to calculate the inculsive percentage so i have to divide the actual sales ,column 2, by the maximum value of the inculsive percentage which is 2370 in this case.

Do you have any solution please ?

i tried to apply the formula but it does not work and please be informed that the inculsive percentage is not a dimension it is an expression.

To sum up the formula for inculsive percentage= actual sales/ Max(inculsive percentage).

Best regards,

Alâa Eddine.

[sunny_talwar]

Suppose your expression for actual Sales is Sum(Sales)... you can try this

Total by Year Month

Sum(Sales)/Sum(TOTAL <[Year Month]> Sales)

overall total

Sum(Sales)/Sum(TOTAL Sales)

[Anonymous]

Hello,

thank you for your answer. I tried but it works wrongly because i put a condition to eliminate accuracy value greater than 80%. So when i put your formula qlikview will divide the Sum(sales) by the total sales of all the Aggr Brand [column 2] that have accuracy value less than 80% and greater than 80% both, this is why the last value is 7% and not 100% (normally), but what i want to do is to divide by the total of sales of only the Aggr Brand that have an accuracy value  less than 80%.

Thank you for helping.

Best regards,

Alâa Eddine.

[sunny_talwar]

Would you be able to share your qvw file so that we can look at what you have?

[Anonymous]

Hello,

i do not know why honestly. Can you please tell me how?

Thank you.

[sunny_talwar]

Look here

Uploading a Sample

Preparing examples for Upload - Reduction and Data Scrambling