topic Output According to given condition in QlikView

Output According to given condition

lionking15 — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

Kindly find below given dummy data

Base Table-

Output Required-

My Requirement

i should get sum of amount as per Accnt Number and Agent
i should give output(i.e Required Field)as per first occurrence of Accnt Number and Agent on Date.

lionking15 — Fri, 22 Sep 2017 09:05:45 GMT

Hi,

And One 'Accnt Number' can have multiple 'Agent' and that number is not fixed.

vinieme12 — Fri, 22 Sep 2017 09:21:55 GMT

use Autonumber()

LOAD AccntNumber

Agent,

Capping,

Sum(Amount) as Sum_Amt,

Autonumber(Agent & Date , Agent) as NEWFIELD

FROM XX

Group by AccntNumber,Agent,Capping;

hari8088 — Fri, 22 Sep 2017 09:34:23 GMT

Hi,

See the attached qvw.

effinty2112 — Fri, 22 Sep 2017 10:53:54 GMT

Hi Giridhar,

Maybe:

Accnt Number	Agent	Sum(Amount)	min(Capping)	RowNo()
1	a	20	30	1
1	b	18	30	2
1	c	30	30	3
2	a	40	30	1
2	b	70	30	2
3	b	50	30	1
4	c	60	30	1
5	a	30	30	1
5	c	20	30	2
6	c	80	30	1

Regards

Andrew

vinayakg — Fri, 22 Sep 2017 11:44:40 GMT

Hi Giridhar,

Please Find the attached File, It may Help u to get ur required answer.

Accnt Number	Agent	Sum(Amount)	min(Capping)	RowNo()
1	a	20	30	1
1	b	18	30	2
1	c	30	30	3
2	a	40	30	1
2	b	70	30	2
3	b	50	30	1
4	c	60	30	1
5	a	30	30	1
5	c	20	30	2
6	c	80	30	1

Accnt Number	Agent	Sum(Amount)	min(Capping)	RowNo()
1	a	20	30	1
1	b	18	30	2
1	c	30	30	3
2	a	40	30	1
2	b	70	30	2
3	b	50	30	1
4	c	60	30	1
5	a	30	30	1
5	c	20	30	2
6	c	80	30	1

Accnt Number	Agent	Sum(Amount)	min(Capping)	RowNo()
1	a	20	30	1
1	b	18	30	2
1	c	30	30	3
2	a	40	30	1
2	b	70	30	2
3	b	50	30	1
4	c	60	30	1
5	a	30	30	1
5	c	20	30	2
6	c	80	30	1