topic Re: Calculate the formula only for the same sub in QlikView

Calculate the formula only for the same sub

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

Hello,

please find attached this table.

I want to show as you can see here the data two subsidiaries ess spain and nexo but i noticed that cumul sales works correctly only if want to show the data of one subsidiary. What i want exaclty is to apply the cumul sales formula only if it is the same subsidiary name.

This is the formula of cumul sales: RangeSum(Above(TOTAL ([Actual Sales]), 0, RowNo(TOTAL)))

Thanks for your help!!!

Alâa Eddine.

Re: Calculate the formula only for the same sub

sunny_talwar — Wed, 03 Oct 2018 10:43:17 GMT

Try this

Aggr(RangeSum(Above([Actual Sales], 0, RowNo())), Subsidiary, YearMonth)

Re: Calculate the formula only for the same sub

Anonymous — Wed, 03 Oct 2018 13:31:14 GMT

Hello, sorry but it does not work. Do you have any other idea?

Thank you.

Alâa Eddine.

Re: Calculate the formula only for the same sub

Anonymous — Wed, 03 Oct 2018 13:31:37 GMT

Hello, sorry but it does not work. Do you have any other idea?

Thank you.

Alâa Eddine.

Re: Calculate the formula only for the same sub

sunny_talwar — Wed, 03 Oct 2018 13:35:26 GMT

Did you use the correct field names within the Aggr function?

Aggr(RangeSum(Above([Actual Sales], 0, RowNo())), Subsidiary, YearMonth)

Also, I noticed that you have a cyclic group for your second dimension.... where you on Subsidiary dimension when you looked at the chart?

It might help if you are able to share a sample to look at

Re: Calculate the formula only for the same sub

Anonymous — Wed, 03 Oct 2018 13:39:51 GMT

Hello,

thank you for responding.

i really do not know how to share the chart but i applied your formula and it works but not like i want.

thanks,

Alâa Eddine.

Re: Calculate the formula only for the same sub

sunny_talwar — Wed, 03 Oct 2018 13:55:08 GMT

Not the chart, but the app

Preparing examples for Upload - Reduction and Data Scrambling

Uploading a Sample