Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
marcorizzo
New 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
Honored Contributor II

Re: help on pivot table

hiiii

see the attached file

marcorizzo
New Contributor III

Re: help on pivot table

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.

Community Browser