topic Re: totals in table in QlikView

totals in table

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

Hello,

I have then next table and i would like to know how to calculate correctly the sales.

It is posible to make the total like this?

thank you

Anonymous — Wed, 05 Apr 2017 15:19:46 GMT

Pablo,

Go to the presentation tab and check partial sums for your yearmonth dimension and another dimension at level2.

krishnacbe — Wed, 05 Apr 2017 15:27:53 GMT

Hi,

Check the sample attached

Anonymous — Wed, 05 Apr 2017 15:27:58 GMT

still makes the sum of the objective

Anonymous — Wed, 05 Apr 2017 15:36:52 GMT

Create a inline table

Dim1:

Load * inline [

Dim

2];

Now use this as dimension

pick(Dim,<Your dimension>,'Total')

Thu, 06 Apr 2017 12:17:13 GMT

Hi,

Can you please try this expression once.

Sum(Total <Type> Sales)

Thanks,