topic Re: Sum in QlikView

Sum

upaliwije — Sat, 14 Jan 2017 11:27:25 GMT

In my QV document I have data in the following manner

TYPE	SEQ	Nos
CLAIM_PAY_NOS	16	10,376
COMM_ENTRIES	14	54,350
COMM_PAYMENT	17	4,737
COMM_PAYMENT	20	4,737
COMM_REVERSAL	15	3,805
CREDIT_NOTES	10	4,920
DEBIT_NOTES	9	25,689
JOURNAL_ENTRY	27	19,908
JOURNAL_ENTRY	28	19,908
NPCREDIT_NOTES	49	1,543
POLICIES	-	56,697
RECEIPTS	7	61,382
RECEIPTS	8	61,382
RECEIPTS	11	61,382
RTN_CHEQUE	48	331
SUNDRY_PAYMENT	18	8,315
SUNDRY_PAYMENT	21	8,315

I want to sum this to obtain and out put like the table below . But I am unable to do since some type are dupicated with nos Pls help me to take output report

TYPE	Nos
CLAIM_PAY_NOS	10,376
COMM_ENTRIES	54,350
COMM_PAYMENT	4,737
COMM_REVERSAL	3,805
CREDIT_NOTES	4,920
DEBIT_NOTES	25,689
JOURNAL_ENTRY	19,908
NPCREDIT_NOTES	1,543
POLICIES	56,697
RECEIPTS	61,382
RTN_CHEQUE	331

Re: Sum

vinieme12 — Sat, 14 Jan 2017 11:33:19 GMT

Load Distinct TYPE

min(SEQ),

min(Nos)

From YourTable

Group by TYPE;

Re: Sum

upaliwije — Sat, 14 Jan 2017 11:42:05 GMT

There are some more fields in my Document If I group it It will affect my other Calculations as well. Is there any other way to get my result without reloading data

Re: Sum

MindaugasBacius — Sat, 14 Jan 2017 11:51:33 GMT

Use simple table object with Nos and Type fields.

Or use pivot table and in expression use:

Sum(DISTINCT Nos)

Re: Sum

satheshreddy — Sat, 14 Jan 2017 11:54:03 GMT

Hi Upali,

can you check the below Script For your Output?

Regards

Sathish

Re: Sum

satheshreddy — Sat, 14 Jan 2017 11:57:13 GMT

Hi Upali,

Use straight and write the below condition. you will get the out put.

Dimension --- TYPE

Exp --- Sum(Distinct Nos)

Regards

Sathish

Re: Sum

vinieme12 — Sat, 14 Jan 2017 12:01:07 GMT

Sum(Distinct Nos)

Avg(Nos)