Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Skip the ticket, Chat with Qlik Support instead for instant assistance.
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.