Discussion Board for collaboration related to QlikView App Development.
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 🙂
Hi
I think you may use AGGR function in a calculated dimension like this
Aggr(Count(Campaign_Id),Customer)
best regards
chris
Hi
I think you may use AGGR function in a calculated dimension like this
Aggr(Count(Campaign_Id),Customer)
best regards
chris
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.