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

[buzzy996]

i think ur expecting total as 17, just remove distinct on ur range table expression and see?

[Anonymous]

in qvw you can already see total as 8

as your claim ID falling in different rang thats what they counted twice in list.

Thanks

BKC

[upaliwije]

wHAT i WANT IS 8 AS THE ANSWER EVEN AGAINST RANGE. IN ANY CASE THERE ARE ONLY 8 CLAIM NOS

[buzzy996]

ur range table already showing as 8,wht else ur looking for?

[upaliwije]

there are only 8 claims . therefore first i want to group them by claim no and then apply range

[sunny_talwar]

by group by you mean you want to add all the amount against a specific claim_no and then give it a range? For instance claim_no 1 has amounts: 100,300,400 -> you want to add them up (which is 800) and then assign it to the range >500??

Is that what you are trying to do?

Best,

Sunny

[upaliwije]

Yes that is exactly what I want

[sunny_talwar]

‌there is two ways you can do that, either in the script or the front end... Do you prefer one or the other?

[Anonymous]

Use this