Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Calculate dimension

hi,

I have a data set like below.

 

CustomerCost1Cost2Revenue
A1030100
B2010200
C3020300

I want to create a calculated dimension for customers based on cost1 and cost2,

i want only those customer in my calculated dimension, when sum(cost1)+sum(Cost2)>=50.

thanks

Prasanta

1 Solution

Accepted Solutions

Re: Calculate dimension

Alternative solution is to use a set analysis like this:

=Sum({<Customer = {"=Sum(Cost1) + Sum(Cost2) >= 50"}>}Revenue)

With Customer as the dimension

Capture.PNG

2 Replies

Re: Calculate dimension

You can try this as your dimension:

=If(Aggr(Sum(Cost1) + Sum(Cost2) >= 50, Customer), Customer)


Capture.PNG

Re: Calculate dimension

Alternative solution is to use a set analysis like this:

=Sum({<Customer = {"=Sum(Cost1) + Sum(Cost2) >= 50"}>}Revenue)

With Customer as the dimension

Capture.PNG

Community Browser