topic Re: Making an expression a dimension in QlikView

Making an expression a dimension

Anonymous — Mon, 25 Mar 2013 14:47:31 GMT

Hi,

I can't get my mind around this one. I have a number of customers who we do mailings to, but we don't want to mail them too often. I'm tracking the number of mailings we're sending in my expression, but I would like to load it as a dimension, so I can filter on it. E.g. of data

Customer	Campaign Id
A	1
A	2
A	3
B	1
B	2
C	1

In my expression I simply count(Campaign Id) and it turns out like this:

Customer	Count(Campaign Id)
A	3
B	2
C	1

I would very much like to load this count in my script, so I could filter out anyone who had been mailed e.g. 3 times or more and also being able to filter on those not mailed yet... But when I try to load it in my script I only get the value of 1.

I hope it makes sense and thank you for your help in advance 🙂

Re: Making an expression a dimension

Mon, 25 Mar 2013 15:13:55 GMT

I think you may use AGGR function in a calculated dimension like this

Aggr(Count(Campaign_Id),Customer)

best regards

chris

Re: Making an expression a dimension

Anonymous — Mon, 25 Mar 2013 15:27:45 GMT

Hi Chris

Can't believe it was that simple! Never really understood the Aggr function, but it did exactly what I wanted, thank you very much.