topic Rangecount() help needed in QlikView

Rangecount() help needed

Sun, 10 Oct 2010 19:33:00 GMT

Dear All,

I'm trying to create a rangecount() expression that will count number of appearances up to a given column e.g. (see the attached tables) if John appears once he gets 1 in Apr; Peter, on the other hand, appears 3 times thus he gets 1,2 and 3 in Feb, Mar and Apr respectively.

Could you please give a hint how to create such a counter?

BR,

Przemek

Rangecount() help needed

Mon, 11 Oct 2010 07:40:05 GMT

Hi,

Please see the attached qvw. I have taken your sample data and had a workaround to modify the expression.

Thanks & Best Regards

Kuldeep Tak

Rangecount() help needed

Mon, 11 Oct 2010 11:39:20 GMT

Thank you, Kuldeep. Would you yet know how to modify the expression to:

1) get zeros in months where Name doesn't appear

2) get totals right if you add years to data.

as it is done in the attached file.

BR, Przemek