topic w/ Calculated Dimensions, what should expression look like? in QlikView

w/ Calculated Dimensions, what should expression look like?

Tue, 12 Oct 2010 18:12:15 GMT

Hello,

Hi,

I'm trying to display loyalty by the latest year puchased vs. the number of years purchased.

I have 2 calculated dimensions in a pivot table:

=aggr(count(distinct Year),GrpEnt)

=aggr(max (Year),GrpEnt)

So, how should my expression look ?

count(aggr(max(Year),GrpEnt)) gives me a number that's in the ballpark, but Im not sure it's right?

I'd appreciate any help.

Thanks - Tim

w/ Calculated Dimensions, what should expression look like?

pover — Wed, 13 Oct 2010 05:45:36 GMT

Tim,

It will probably give you the same result, but formula probably should be count(distinct GrpEnt) to how many GrpEnt are found in the grouping you making dynamically in the calculated dimensions for # of years and latest year. Since aggr() returns a list and the count returns the number of the GrpEnt 's in the list it will probably give you the same result, but it's simpler to use count(distinct GrpEnt).

Regards.

w/ Calculated Dimensions, what should expression look like?

Tue, 09 Nov 2010 16:44:08 GMT

Belated, thank you 🙂