Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Need to drill down

Header 120132012
AXXXXXXXX
BXXXXXXXX
CXXXXXXXX

D

XXXXXXXX

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 1Header 220132012
AXXXXXXXXX
YXXXXXXXX
BPXXXXXXX
QXXXXXXX
RXXXXXXX
3 Replies
Not applicable
Author

Amrit,

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

richard

Not applicable
Author

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

Not applicable
Author

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