topic Re: Need to drill down in QlikView

Need to drill down

Fri, 13 Jun 2014 16:58:22 GMT

A,B,C,D are my expression

year is my dimension

now A=X+Y

B=P+Q+R

C=C

D=S+T+U

now my table should look like:

Header 1	Header 2	2013	2012
A	X	XXXX	XXXX
A	Y	XXXX	XXXX
B	P	XXX	XXXX
	Q	XXX	XXXX
	R	XXX	XXXX

Fri, 13 Jun 2014 17:02:14 GMT

Amrit,

Not sure from your question, but pivot table should suffice.

richard

Fri, 13 Jun 2014 17:17:36 GMT

the First table is what i have and the second table is what i want

Tue, 17 Jun 2014 09:30:40 GMT

Amrit,

If I can make an assumption based on your question. A and B could be countrys and X,Y,P,Q,R could be regions, of it could be regions and Salesman.

I have attached an example.

If this does not help, please explain in a little more detail

Richard