Need Expression Help - Sales Per Peg

Wed, 09 Nov 2011 16:30:33 GMT

Hi everybody! I'm struggling to come up with an expression that gives me what I'm looking for. I have sales data by store, by month, by item. I also have the number of facings/pegs that an item takes up on the wall in the store.

I'm trying to find an expression that will tell me which brand, sub brand, item, etc. is utilizing its space on the wall the best.

For example, I have a wall that has pegs for 55 items. Items under Brand_A have sales of $10,300. Items under Brand_B have sales of $26,400. However, Brand_A only has 15 pegs on the wall where as Brand_B has 40 pegs on the wall. So the formula of dollars/facings shows that Brand_A has $686.87 per peg while Brand_B only has $660 per peg.

I want to be able to see the sales per facing whether I am looking at brand or sub brand.

Attached is an example in Excel that may make more sense.

Does anyone know what I can do?

Thanks,

Justin

Re: Need Expression Help - Sales Per Peg

john_duffy — Thu, 10 Nov 2011 13:13:36 GMT

Hi Justin.

I have attached an example using the Aggr function. Let me know if this helps.

John.

Need Expression Help - Sales Per Peg

Thu, 10 Nov 2011 13:28:09 GMT

Thanks, John!!

topic Need Expression Help - Sales Per Peg in QlikView

Need Expression Help - Sales Per Peg

Re: Need Expression Help - Sales Per Peg

Need Expression Help - Sales Per Peg