Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Making an expression a dimension

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
A1
A2
A3
B1
B2
C1

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

Customer Count(Campaign Id)
A3
B2
C1

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 🙂

1 Solution

Accepted Solutions
Not applicable
Author

Hi

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

Aggr(Count(Campaign_Id),Customer)

best regards

chris

View solution in original post

2 Replies
Not applicable
Author

Hi

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

Aggr(Count(Campaign_Id),Customer)

best regards

chris

Anonymous
Not applicable
Author

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.