Add different dimensions

[#1]

Good afternoon,

I have three wineries represented in tables SKU, such as image STOCK

I need to add the stock and show the final stock of each SKU, the problem is that the 3 wineries not necessarily have the same SKU, so I can not do addition.

can you help me?

[Peter_Cammaert]

If different sku's (one for each winery) refer to the same product, map the different sku's to a common one (of your own invention, maybe an automatically generated number for internal QlikView use)

Sooner or later you'll have to tighten things up (tie the tables together)

[daveamz]

Hi,

Try =RangeSum([stock A], [stock B], [stock C])

Regards,

David

[sunny_talwar]

‌So are you saying that sku2 from one winery = sku5 in 2nd winery? How would you even know which sku's are the same from different winery? Do you have some kind of key which maps them? unless you have that, I don't see how you will make this work.

[sfatoux72]

Hi Jorge,

When you make an addition ( [stock A]+[stock B]+[stock C] ), if one of the element is NULL, the result will be NULL.

To avoid that, you need to use the Range function ( RangeSum([stock A], [stock B], [stock C]) ).

[#6]

Thanks Sebastien, thats works fine for me, now i have another problem,

in the same example i need group RangeSum([stock A], [stock B], [stock C]) and Sku's by another dimension "Manufacturer"

Where:

SKU = Count(Manufacturer) - this expression its different to Sku Dimension

Stock Final = RangeSum([stock A], [stock B], [stock C])

But that isnt working,

Could you help me?

[sfatoux72 · Accepted solution]

The previous expression works only on lowest level (Sku)

In aggregated level (Manufacturer) you need to use :

RangeSum(Sum([stock A]), Sum([stock B]), Sum([stock C]))

This expression works in lowest level too.

Don't forget to mark the answer "Correct" to help others.

[#8]

Thanks!!!

thats works fine!

[oknotsen]

If your question is answered, please flag the Correct Answer.

If not, please let us know what part of the current topic needs more explaining.