topic Re: Buckets..... in QlikView

Buckets.....

Tue, 18 Jun 2013 13:16:18 GMT

Hi Folks

I have a simple table consisting of: UserName, Date, Hits

I'd like to produce a chart/table to look like this:

Bucket # Users

0 nnnnnn

1 nnnnnn

2-5 nnnnnn

6+ nnnnnn

Where the bucket represents the number of distinct days that a client has had at least one hit, and the #users represents the number of distinct clients within that bucket.

Any ideas on approach?

I can't do this in the laod script because the actual data model is more complex than the above, so the IntervalMatch function is not something I'm going to be able to use in this case.

Re: Buckets.....

alexandros17 — Tue, 18 Jun 2013 13:32:45 GMT

If your column is "Col" than use something like this

(rank(Count(Col))<5,

rank(Count(Col)),

'More than 5'

)

Re: Buckets.....

Tue, 18 Jun 2013 14:56:01 GMT

Thanks for response, but......

I'm not sure what that means but I am fairly certain that the solution is nowhere near that simple, my columns are UserName, Date, Hits so which one of those does your column name of Col refer?

In the solution I'm assuming that the dimension needs to be a calculated dimension using Aggr statements along with IF....THEN....ELSE statements, and that the expression should be a distinct count of user name as long as the calculated dimension will support this.