Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Uploads getting stuck in the virus scanner. We are investigating.
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

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
Highlighted
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
Highlighted
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