topic Re: sum up values from different worksheets in QlikView

sum up values from different worksheets

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

Hello everybody,

is it possible to sum up calculated fields from other worksheets in an external worksheet?

In the present example, this means that for a given number of pieces produced, there are a certain amount of samples. I have assigned the quantity of the sample to each order. Now, on another worksheet, I want to create a year statistic and a month statistic in which I want to sum up the set of samples.

Thanks,
Dominic

Re: sum up values from different worksheets

avinashelite — Wed, 29 May 2019 08:53:53 GMT

Yes , possible . Could you please share the sample data ? so that we could guide you

Re: sum up values from different worksheets

dominicanlauf — Wed, 29 May 2019 09:10:18 GMT

Unfortunately I can not create a table in the script (because access rights to the data sources are necessary, which I don't have). Therefore I calculate the number of samples with nested if-functions in the "order data" table.

I hope the screenshot will help out.