topic Aggregation Dimension against Expression in QlikView

Aggregation Dimension against Expression

Anonymous — Fri, 24 Feb 2012 13:21:53 GMT

Dear All

I have Requirement Where i have data in the following Format

Customer	Product Purchased	Days Purchased
A	AA	10
B	BB	20
A	CC	30
B	DD	40
A	AA	50
B	BB	60
A	CC	70
B	DD	80

I Want a chart in the following Format.

Customer	No Of Product	Latest Product Purahased(min(days))	Slot
AA	2	10	0-30
BB	1	20	0-30
AA	1	50	31-60
BB	2	40	31-60
AA	1	70	61-90
BB	1	80	61-90

The slot field is just for understanding purpose it should b hided

The bifurcation of customer is done on basis of slots

and the day shown is minimum again each customer for the particular slot .

Aggregation Dimension against Expression

swuehl — Fri, 24 Feb 2012 13:45:28 GMT

You could do it in the front end like this:

Create a straight table chart with two dimensions

=class([Days Purchased],30,'x',1)

as calculated dimension and

Customer

Then create two expressions:

=count([Products Purchased])

and

=max([Days Purchased])

Hide the first, calculated dimension in presentation tab.

You could do similar in the script, creating a flag field to indicate the buckets and then do the expression calculation in a group by load, if you don't need to be sensitive to selections.

Regards,

Stefan

Aggregation Dimension against Expression

fernando_tonial — Fri, 24 Feb 2012 13:48:43 GMT

You can try the Class Function.

Class([Days Purchased], 30)