topic stock availability ratio in QlikView

stock availability ratio

Thu, 10 Mar 2011 19:12:27 GMT

Hi All,

I'm trying to report my stock availability. My data is consist of three fields; "Product Group" , "Part Number" and "Stock Quantity"

I've got 200 part numbers, 180 of them are in stock ([stock quantity]>0), 20 of them out of stock ([stock quantity]=0).

How can I make a presentation that says 90% available, 10% not available? And if I filter product groups I can see their availability ratios.

I've attached a sample data for your reference.

Thanks,

Mem

stock availability ratio

Thu, 10 Mar 2011 19:39:03 GMT

Hi,

The following expression should give you what you are looking for. I have wrapped it in a Num function in case you want to put the expression in a Text Object.

=Num(Count({$<[Stock Level]={">0"}>}[Stock Level])/Count([Stock Level]),'#,##0%')

I hope this helps.

Thanks

Nick

stock availability ratio

Fri, 11 Mar 2011 09:57:27 GMT

Spot on! Works beautifully. Thanks Nick.