Probleme with where function

Sun, 22 Jul 2012 11:15:28 GMT

I would like to create a table with only the data which has the same ID than an other table.

The Solver table contains ID ans the service where in took only one service (GCE_RS)

The activités table contains all data about activity with ID but no service. There are too many ID here because it's the id of all services.

I want to load this table with only the id collected from the solver table.

I tried with : Where [N Incident] = solver_case_id

i tried with differents ways with the where fonction, with or without the table name, but no way to succes...

I need your help please

Stéphane

/////////////////////////////////////////////////////////////

Solver:

LOAD solver_case_id as [N Incident],
     solver as Service
FROM
[\\s-vm-qvw-01\SM7\p_solver_table_GCE_RS.qvd]
(qvd)
where solver like ('GCE_RS') ;

////////////////////////////////////////////////////////////////// Create activity table with Only the id from the solver table!

Activités:
LOAD
solver_case_id as [N Incident],
     DATESTAMP as [Date mouvement],
     OPERATOR as Opérateur,
     TYPE as Statut,
     date(if(TYPE = 'Closed', DATESTAMP, if(previous(solver_case_id) = solver_case_id, previous(DATESTAMP), today() ))) as [Date fin]
FROM
[\\s-vm-qvw-01\SM7\activity_GCE_RS.qvd]
(qvd)

where [N Incident] = solver_case_id ; <- the problem is in this line

Re: Probleme with where function

nagaiank — Sun, 22 Jul 2012 11:28:05 GMT

In the load script for Activités table, change the where clause from

where [N Incident] = solver_case_id ;

where exists([N Incident], solver_case_id);

Re: Probleme with where function

Sun, 22 Jul 2012 11:31:01 GMT

Yes!

Thank you very much

topic Re: Probleme with where function in QlikView

Probleme with where function

Re: Probleme with where function

Re: Probleme with where function