topic witch formula for doing that in QlikView

witch formula for doing that

doespirito — Mon, 06 Mar 2017 15:07:05 GMT

hi,

i have 3 dimensions and datas :

cost_center, nbex, nbdays

103601, 178359, 26

103602, 73557, 26

103603, 70689, 26

in a formula, i want to calculate the average nbex per day :

178359/26 + 73557/26 + 70689 / 26

that is : 6859 + 2829 + 2719 = 12407

of course sum(nbex) / sum(nbdays) doesn't work.

could anyone help me ?

thank you very much.

Re: witch formula for doing that

sunny_talwar — Mon, 06 Mar 2017 15:07:55 GMT

Try this

Sum(nbex/nbdays)

Re: witch formula for doing that

doespirito — Mon, 06 Mar 2017 15:15:19 GMT

ok thank you,

i have set analysis for each part :

sum({<RATIO={'EXPOR'}>} REEL_RAT)/sum( {<RATIO={'NBPAR'}>} REEL_RAT)

how to transform in Sum(nbex/nbdays) ?

Re: witch formula for doing that

sunny_talwar — Mon, 06 Mar 2017 15:16:30 GMT

May be this:

Sum({<RATIO={'EXPOR', 'NBPAR'}>}nbex/nbdays)

Re: witch formula for doing that

doespirito — Mon, 06 Mar 2017 15:25:08 GMT

REEL_RAT contains nbex with set analysis {<RATIO={'EXPOR'}>}

and nbdays with set analysis {<RATIO={'NBPAR'}

so it's difficult to do this

Re: witch formula for doing that

sunny_talwar — Mon, 06 Mar 2017 15:26:46 GMT

Do you have a sample where you can share? Without knowing your data, it would be difficult for me to propose anything here

Re: witch formula for doing that

doespirito — Mon, 06 Mar 2017 15:53:09 GMT

thank you

here is my exemple,

i want 12407 and not 4136

Re: witch formula for doing that

sunny_talwar — Mon, 06 Mar 2017 15:58:50 GMT

Try this:

='wrong total : '&num(Sum(Aggr(Sum({<RATIO={'EXPOR'}>} REEL_RAT)/sum( {<RATIO={'NBPAR'}>} REEL_RAT), COST_C)),'# ##0')

Re: witch formula for doing that

doespirito — Mon, 06 Mar 2017 16:03:52 GMT

yes it works fine...

thanks a lo

Re: witch formula for doing that

sunny_talwar — Mon, 06 Mar 2017 16:06:24 GMT

If you got the solution using my response above, I would suggest you to mark my response as correct and/or helpful instead of marking your own as helpful. This will help future visitors.

Qlik Community Tip: Marking Replies as Correct or Helpful

Thanks,

Sunny