topic Re: Percent Calculation using Max Function in QlikView

Percent Calculation using Max Function

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

Hi all,

I have a Straight Table which is having calculation like below:

Sum(UnitsSold)/max(Forecast).

In the above example the calculation should be 715/252 = 2.83.

The same calculation we need to capture in Single field, as we need to use this in Set expression.

The calculated field is capturing data in row level, and summing up. And showing 5.29.

But I need 2.83 should show in the last column and it should repeat for each row.

Could anyone help me do the same.

I am attaching a sample qvw.

Please help.

Thanks,

Sarif

Re: Percent Calculation using Max Function

ogautier62 — Fri, 01 Jun 2018 10:33:27 GMT

maybe :

Sum(total UnitsSold)/max(total Forecast) ?

if you omit "total " that sums each line

regards

Re: Percent Calculation using Max Function

prat1507 — Fri, 01 Jun 2018 10:34:24 GMT

Please see the attached app.

Regards

Pratyush

Re: Percent Calculation using Max Function

Anonymous — Fri, 01 Jun 2018 10:34:57 GMT

Dear Mohammad,

Max Function use in Script - And Group by.

Use value in the front Expression.

Re: Percent Calculation using Max Function

tresB — Fri, 01 Jun 2018 10:35:43 GMT

Try:

=sum( total UnitsSold)/Max(total ForecastQuantity)

Re: Percent Calculation using Max Function

mhmmd_srf — Fri, 01 Jun 2018 10:38:53 GMT

are you trying to say in script? or in front end.

I have a feild called[UnitsSold/ForecastQuantity].I need to use this only.

because we need to use the same field in another calculation in next chart.

Re: Percent Calculation using Max Function

mhmmd_srf — Fri, 01 Jun 2018 10:39:38 GMT

I already tried the same. But result is same.

Re: Percent Calculation using Max Function

mhmmd_srf — Fri, 01 Jun 2018 10:46:46 GMT

hi Pratyush,

Thanks for your reply.

Instead of creating variable, if we use max(Forecast) in denominator, then also it is working.

But i want to use the field [UnitsSold/ForecastQuantity]. As this would be using in Set expression next chart calculation.

Thanks,

Sarif

Re: Percent Calculation using Max Function

tresB — Fri, 01 Jun 2018 10:52:59 GMT

With the field [UnitsSold/ForecastQuantity] alone, I don't see a logic of calculating back what you are looking for. It (the possibility of solution) would be simple mathematics rather than qlik for understanding what you are trying to get.

Re: Percent Calculation using Max Function

prat1507 — Fri, 01 Jun 2018 10:57:14 GMT

You can probably use [UnitsSold/v_n_max_val] in your next chart.

Regards

Pratyush