topic Re: Sub Field Caculation in QlikView

Sub Field Caculation

Wed, 19 Nov 2014 04:48:37 GMT

Dear All,

Greeting for the Day...!!!

I have a requirement to find out the Main Filed and Sub field out of Hierarchy table.

Input Format:-

*A*B*C

*G*D

*U*F*J*K*L

*M*I*T*H*T*R*D*V

OutPut Table should be:-

Main Group	Sub Group	Last Group
A	B	C
G		D
U	F	L
U	J	L
U	K	L
M	I	v
M	T	v
M	H	v
M	R	v
M	D	v

Please help me out to get the solution for this.

Thanks!

D J

Re: Sub Field Caculation

tresB — Wed, 19 Nov 2014 05:09:48 GMT

May be like attached qvw.

Re: Sub Field Caculation

anbu1984 — Wed, 19 Nov 2014 05:33:15 GMT

Load SubField(Txt,'*',2) As MainGrp, If(Cnt>2,SubField(Txt,'*',3+(IterNo()-1))) As SubGrp, SubField(Txt,'*',Cnt+1) As LastGrp While IterNo() <= If(Cnt>2,Cnt-2,1);

LOad *,SubStringCount(Txt,'*') As Cnt Inline [

Txt

*A*B*C

*G*D

*U*F*J*K*L

*M*I*T*H*T*R*D*V ];