sum

[upaliwije]

I have attached a QV document with two straight table

Claim_No	count(DISTINCT Claim_No)
1	1
2	1
3	1
4	1
5	1
6	1
7	1
9	1
	8

Range	count(DISTINCT Claim_No)
200-300	2
300-400	2
400-500	2
100-200	3
>500	5
	14

In one table total count is 8 where as in the it is 14 against range. I want to show show total as 8 in Range table also. pls help me

[upaliwije]

I like to know both ways

[sunny_talwar]

Script method using group by statement:

claim:

load * inline [

Claim_No, Amount,

1 ,100

2 ,200

3 ,300

4 ,400

5 ,500

6 ,600

7 ,100

9 ,200

1 ,300

1 ,400

2 ,500

3 ,600

4 ,400

4 ,800

4 ,100

5 ,500

6 ,700

];

Join(claim)

LOAD Claim_No,

  Sum(Amount) as TotalAmt

Resident claim

Group By Claim_No;

Join(claim)

load

Claim_No,

Amount,

if(TotalAmt>=0 and TotalAmt<100, '0-100',

if(TotalAmt>=100 and TotalAmt<200, '100-200',

if(TotalAmt>=200 and TotalAmt<300, '200-300',

if(TotalAmt>=300 and TotalAmt<400, '300-400',

if(TotalAmt>=400 and TotalAmt<500, '400-500',

if(TotalAmt>=500 , '>500'))))))as Range

resident claim;

[sunny_talwar · Accepted solution]

Here is how you do this in the front end (PFA)

HTH

Best,

Sunny

[upaliwije]

Thanks a lot for all

[sunny_talwar]

Not a problem.

Best,

Sunny

[upaliwije]

Can You please tell me how to assign a name for calculated dimension

[sunny_talwar]

Look at the image:

.

HTH

Best,

Sunny

[upaliwije]

Tks