Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, my table looks as follows:
I would like my object to calculate the number of units sold.
Basically my calculation should work as follows:
For each ITEM NO do the following:
sum (Invoice Quantity)
------------------------------------- and then sum this answer for all items in the end.
packsize UOM
how do i write this on my object to calculate like this???
1:Use a straight table
2: dimesnion : [Item no]
3: expression sum([Invoice qty])/[Packsize UOM]
4:show expression total
regards
Pradosh
Hi Pradosh,
I want to use a chart as I'm doing sales trending.. ZAR values vs Total Tonnage vs Total Units
See screenshot of my charts. I'm basically looking to create the 3rd total units chart.
Current formula in these charts are basically:
sum( { < [Trending Value] = {"MP"} > }[Invoiced Quantity])
May be this
sum(aggr(sum([Invoice qty])/[Packsize UOM],[Item no]))
How do I add my set analysis in this for the MACHINE PACK, HAND PACK etc??
currently the formula looks as follows:
sum( { < [Trending Value] = {"MP"} > }[Invoiced Quantity])
try like this
sum( { < [Trending Value] = {'MP','HP'} > }[Invoiced Quantity])
or
sum( { < [Trending Value] = {"MP"} , YourField = {"HP"} > }[Invoiced Quantity])
Hi Rani
i guess above is the solution by MP but you should consider reading this once as it may appear as a bug in future
double quotes are case insensitive so make sure what you use is right for your requirement?
did we answer your question.
Hi pradosh,
I'm really new a qlikview and need you guys to dumb it down for me..
I need my chart to do the above calculation for me, and then furthermore need to do it for machine packed vs hand packed items.
the packing method is item no specific.
I've tried the following code, but it is not working:
sum({<[Trending Code] = {"MP"} > }(aggr(sum([Invoiced Quantity])/[Packsize UOM],[Item no])))
Try like this
sum((aggr(sum({<[Trending Code] = {"MP"} > }[Invoiced Quantity])/[Packsize UOM],[Item no])))