topic Re: Alternative to GetPossibleCount() in QlikView

Alternative to GetPossibleCount()

Anonymous — Thu, 18 Dec 2014 13:09:12 GMT

hello,

I have a little problem on a formula for calculating the value of the average quantity delivered my formula : sum(CE11000.Sales_Quantity) / GetPossibleCount (CE11000.Period)

This works very well when my product was delivered during the 6 months selected but here my article is delivery only in March so in the formula the GetPossibleCount = 1 and I wish it all the time equal to my selection here I want GetPossibleCount = 6.

Do you have any idea?

Thank you in advance!

Re: Alternative to GetPossibleCount()

Aurelien_Martinez — Thu, 18 Dec 2014 13:37:40 GMT

Hi,

I think this expression can help you :

sum(CE11000.Sales_Quantity) / Count({<CE11000.Period=>} DISTINCT CE11000.Period)

Aurélien

Re: Alternative to GetPossibleCount()

Thu, 18 Dec 2014 13:43:27 GMT

Did you try the below

GetPossibleCount(CE11000.Period)+GetAlternativeCount(CE11000.Period)

Re: Alternative to GetPossibleCount()

Anonymous — Thu, 18 Dec 2014 14:47:02 GMT

I finally found a solution :

GetSelectedCount(CE11000.Period,1)

Thank you for your answers