topic Re: Calculation problem in QlikView

Calculation problem

mustafaelryah — Sat, 28 Mar 2015 10:51:06 GMT

Hi All,

I have 2 Tables

1. Liabilities Table contains the below Columns

Account ID

MRU

Type Category

Balance

2. MRU Table contains the below Columns

MRU

Department

City

District

* The MRU Lining the 2 tables

**********************************************

My question that I can't get the summation of balances if the balance is more than 400 for each department

but I can get this summation for Account ID.

I made Chart . I set Department as dimension and the expression is if( Balance> 400, Sum(Balance))

this expression give me results when the dimension is Account ID but it gives no results when the dimension is Department.

Can you help me plz.

Regards

maxgro — Sat, 28 Mar 2015 11:39:24 GMT

maybe you need an aggr by dept

sum(if(aggr(sum(Balance),Department)>400, aggr(sum(Balance),Department)))

MK_QSL — Sat, 28 Mar 2015 14:10:49 GMT

You need to Aggregate SUM(Balance) by Department as suggested by Massimo Grossi.

In case if you want the same by Set Analysis, use below

SUM({<Department = {"=Aggr(SUM(Balance),Department)>=400"}>}Balance)

mustafaelryah — Sat, 28 Mar 2015 17:30:42 GMT

Thanks All.

Mon, 30 Mar 2015 12:22:30 GMT

You can try with Aggr Function

Sum(if(aggr(sum(Balance),Department)>400, aggr(sum(Balance),Department)))