topic Maximum value in QlikView

Maximum value

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: Maximum value

sunny_talwar — Wed, 08 Aug 2018 16:33:56 GMT

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)

Re: Maximum value

Anonymous — Thu, 09 Aug 2018 07:53:37 GMT

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.

Re: Maximum value

sunny_talwar — Thu, 09 Aug 2018 10:11:21 GMT

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

Re: Maximum value

Anonymous — Tue, 14 Aug 2018 09:45:30 GMT

Hello,

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

Thank you.

Re: Maximum value

sunny_talwar — Tue, 14 Aug 2018 19:36:28 GMT

Look here

Uploading a Sample

Preparing examples for Upload - Reduction and Data Scrambling