Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello! I have a document loaded into Qlikview. I need to sum inventory by store by SKU number. when I use the formula =sum(inventory) in the expressions is sums all the inventory for the whole company and says that is what each store has on hand. which I know is not correct. Any ideas on what I should try? the document looks like this:
Store Name: On Hand SKU
Store Number 1 4 123456
Store Number 2 7 123456
Store Number 3 6 123456
Store Number 1 8 456789
Store Number 2 9 456789
Store Number 3 2 456789
Create a straight table with Store Name and SKU as dimensions and sum(inventory) as expression.
use
aggr(sum(inventory),[Store Name],SKU)
See attached for a demo.
Any Luck?