topic Re: Add different dimensions in QlikView

Add different dimensions

Fri, 08 Jan 2016 20:23:19 GMT

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?

Re: Add different dimensions

Peter_Cammaert — Fri, 08 Jan 2016 21:34:16 GMT

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)

Re: Add different dimensions

daveamz — Fri, 08 Jan 2016 21:54:23 GMT

Hi,

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

Regards,

David

Re: Add different dimensions

sunny_talwar — Fri, 08 Jan 2016 22:24:27 GMT

‌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.

Re: Add different dimensions

sfatoux72 — Fri, 08 Jan 2016 22:40:16 GMT

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]) ).

Re: Add different dimensions

Tue, 19 Jan 2016 15:05:51 GMT

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?

Re: Add different dimensions

sfatoux72 — Tue, 19 Jan 2016 17:36:43 GMT

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.

Re: Add different dimensions

Tue, 19 Jan 2016 20:03:28 GMT

Thanks!!!

thats works fine!

Re: Add different dimensions

oknotsen — Tue, 19 Jan 2016 21:00:09 GMT

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.