Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
chriys1337
Creator III
Creator III

Using a (self-) calculated dimension with aggr-Function and if-Function possible?

Good evening,

I am wondering if it is possible to do following:

 

I am having Sales per each Customer. If the Sales is bigger 100, it is a Category A customer, if not Category B.

I would like to have a table which shows me my calculated Dimension (Category A / B Customer) and the amount of Customers. The special thing here is, that the dimension is not caluclated in the DM, I need to let this calculate on Frontend Level in a table.

 

Is that possible?

I could imagine it is a combination of aggr(sum(Sales),customer) and the if condition if (Sales>= 100, 'Cat A Customer',' Cat B Customer'), unfortunately I dont get this working. Can anybody please support.

 

Labels (1)
1 Solution

Accepted Solutions
Lisa_P
Employee
Employee

Yes. You can create a calculated dimension.

=Aggr( If(Sum(Sales)>100,' Cat A Customer', 'Cat B Customer')),Customer)

View solution in original post

1 Reply
Lisa_P
Employee
Employee

Yes. You can create a calculated dimension.

=Aggr( If(Sum(Sales)>100,' Cat A Customer', 'Cat B Customer')),Customer)