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: 
marcorizzo
Contributor III
Contributor III

help on pivot table

I have a sql table ‘TAB1’ that is more or less like this :

DATE

TYPE

CODE

EMPLOYEE

FATHERCODE

01/01/2010

CONTRACT

CON001

01/02/2010

TECHNICAL INTERVENTION

-

MARK

CON001

01/03/2010

TECHNICAL INTERVENTION

-

MARK

CON001

01/04/2010

TECHNICAL INTERVENTION

-

JOHN

CON001

01/05/2010

CONTRACT

CON002

01/06/2010

TECHNICAL INTERVENTION

-

DAVID

CON002

01/07/2010

TECHNICAL INTERVENTION

-

PAUL

CON002

I’m trying to obtain this pivot table :

DATE

TYPE

CODE

DATE INTERVENTIONS

EMPLOYEE

01/01/2010

CONTRACT

CON001

-

-

-

-

-

01/02/2010

MARK

-

-

-

01/03/2010

MARK

-

-

-

01/04/2010

JOHN

01/05/2010

CONTRACT

CON001

-

-

-

-

-

01/06/2010

DAVID

-

-

-

01/07/2010

PAUL

                                     DIMENSIONS                                                                         EXPRESSIONS

What do you suggest ?

Please help !!!

Marco

2 Replies
er_mohit
Master II
Master II

hiiii

see the attached file

marcorizzo
Contributor III
Contributor III
Author

Sorry but it doesn't work.

I was wrong because the sql table is a bit different :

DATE

TYPE

CODE

EMPLOYEE

FATHERCODE

01/01/2010

CONTRACT

CON001

01/02/2010

CONTRACT

CON002

01/03/2010

TECHNICAL INTERVENTION

-

MARK

CON001

01/04/2010

TECHNICAL INTERVENTION

-

JOHN

CON002

01/05/2010

TECHNICAL INTERVENTION

-

PAUL

CON002

01/06/2010

TECHNICAL INTERVENTION

-

DAVID

CON001

01/07/2010

TECHNICAL INTERVENTION

-

PAUL

CON002

So I cannot use the date ad dimension.

I really don't know how to go on.