Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Need help

Dear All

My source as below.

CustomerIDAgreementidDPDAMT
100C0120100
100A0230200
100B0410300
200X101180500
200Y10230200
200Z1046060
300M10560400
300N106180500
300O10720300

If  one customer  one Agreementid have DPD>180 i want to show all the Agreementids amt.

Ex:

CustomerIDAgreementidDPDAMT
200X101180500
200Y10230200
200Z1046060
300M10560400
300N106180500
300O10720300
10 Replies
sivarajs
Specialist II
Specialist II

Can you explain your reqiurement clearly

SunilChauhan
Champion
Champion

use below code

sum( if(DPD>=180,AMT))

hope this helps

Sunil Chauhan
Not applicable
Author

it is giving Sum(Amt)=1000, but i want sum(Amt)=1960

adhudson
Creator II
Creator II

Hi,

     PFA.

     I have used a flag field to identify the customer ids which has any one DPD equal to 180.

     Check and let me know if you ve got the solution.

Regards

Andrew Hudson

Michiel_QV_Fan
Specialist
Specialist

Talluru,

here is your solution in an expression:

sum({<customerid = p({$<dpd = {'180'}>}customerid)>}amt)

You can create a variable to replace the fixed value 180, like this:

sum({<customerid = p({$<dpd = {'$(talluru_value)'}>}customerid)>}amt)

use a slider to select the talluru_value

flipside
Partner - Specialist II
Partner - Specialist II

Hi Talluru,

Another option would be to create a calculated dimension in a chart with this ...

=if(aggr(max(DPD),CustomerID)>=180,aggr(max(DPD),CustomerID))

So you have 3 dimensions (CustomerID, Agreementid and the above) then sum(AMT) as your expression.  The calculated dimension sets to Null any value below 180, so you need to tick the box Suppress when Value is Null.

flipside

Not applicable
Author

Here

in Dimension:

dimension 1: =aggr(if(sum(DPD) > 180, CustomerID),CustomerID) //check "Suppress When Value is Null"

dimension 2: Agreementid

dimension3: DPD

in Expression:

sum(AMT)

v_iyyappan
Specialist
Specialist

Hi,

     I attached sample QV file.

     Hope its helps for u

Regards,

Iyyappan

Michiel_QV_Fan
Specialist
Specialist

Please be aware that calculations in a dimension are inefficient compared to calculations in an expression, they take more time and resources.

And,

If the selection is done in the dimension then there are 2 different places to consider for the end result:

  • the limitation of result set in the dimension
  • the calculation in the expression