topic Concat in QlikView

Concat

Mon, 19 Mar 2012 09:05:44 GMT

I have a table which contain following fields:

FormId ,FirstSubmtDate and SubmitDate.

I want to concat the value in Submit Date column, group by formId but i don"t want the values in concat result which are in firstsubmitdate column.

Please help its really urgent.

jagannalla — Mon, 19 Mar 2012 09:19:32 GMT

T1:

Load FormId ,FirstSubmtDate,SubmitDate

From

SourceData;

Res:

Load FormId,

FormId & SubmitDate as SubmitDate1,

Count(FormId) as CountFormId

Resident T1

Group By FormId,SubmitDate ;

Mon, 19 Mar 2012 09:29:00 GMT

can we do the same by using exists clause ????? if yes then plz explain

jagannalla — Mon, 19 Mar 2012 09:42:56 GMT

for exist clause we required field to compare..

Exists:

These functions are used when a value from previously loaded records of data is needed for the evaluation of the current record.

For eg:

Res:

Load FormId,

FormId & SubmitDate as SubmitDate1,

Count(FormId) as CountFormId

Resident T1

Where exist where exists (SubmitDate)

Group By FormId,SubmitDate ;

jagannalla — Mon, 19 Mar 2012 09:57:39 GMT

I think you want this code..

T1:

Load FormId ,FirstSubmtDate,SubmitDate

From

SourceData;

Res:

Load FormId,

FormId & SubmitDate as SubmitDate1,

Count(FormId) as CountFormId

Resident T1

where exists (SubmitDate,FormId & SubmitDate)

Group By FormId,SubmitDate ;