Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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.
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)
Hi,
Try =RangeSum([stock A], [stock B], [stock C])
Regards,
David
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.
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]) ).
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?
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.
Thanks!!!
thats works fine!
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.