topic Re: double rows in QlikView

double rows

Tue, 15 Nov 2011 15:13:16 GMT

Hi,

I need help to take away double rows in my application, see attached file. The only row that should be left are third row. Can I do something in the script?

/Jessica

double rows

Tue, 15 Nov 2011 15:15:58 GMT

Try adding Inner Joins to your script.

Re: double rows

Tue, 15 Nov 2011 15:18:17 GMT

Can you be more specific? Example?

Thanks

/Jessica

double rows

Tue, 15 Nov 2011 15:29:30 GMT

Can you post your script?

double rows

johnw — Tue, 15 Nov 2011 21:02:31 GMT

How do you know it's the third row you want? Whatever that condition is, add it to the script that loads the table.

Re: double rows

Wed, 16 Nov 2011 08:28:18 GMT

Marcsliving - You can find the script above. ct.qvs

John - I think I want the third row because there must allways be a value in the column "stopporsak"

double rows

Wed, 16 Nov 2011 12:16:13 GMT

How do all your tables connect? A table view would be helpful (Would take awhile to search through for matching fields to build myself)

If you always need the field Stopporsak to be populated, then you need to place a join on that table with the connecting table (This is if stopporsak is a description table if the table with stopporsak actually has records with no entry to can place a where clause like: from table where stopporsak<>'').

Re: double rows

Wed, 16 Nov 2011 12:27:57 GMT

See view CT file above.

Yes,there must allways be a value in Stopporsak

Re: double rows

Wed, 16 Nov 2011 12:35:11 GMT

Try adding this to the script:

CSTREASON: //This names the table so you can join to it.

SQL SELECT //bDefault,

//bPTDefRecWaste,

//bPTDefWaste,

//bWebBreak,

//nFacEventTypeId,

nId as ReasonId,

//nSortOrder,

//strCode,

strName as Stopporsak

FROM "mwm_ct_jms".dbo.CSTREASON WHERE strName NOT LIKE '-';

Left Keep (CSTREASON)

SQL SELECT //bLastStop,

//bManual,

//fEndOffset,

//fOffset,

//fRadius,

//nAutomaticEventTypeId,

//nColumnB,

//nCopies,

//nCopyOf,

//nDampPercentage,

//nEventTypeId,

//nExtraCopiesChange,

//nFacEventTypeId,

//nForm,

nId,

//nMachineId as MachineId,

//nMainId,

nOperatorId,

nPaperTension,

//nProcessTypeId,

nReasonId as ReasonId,

//nRepLineRunId,

nRepMachineRunId as RepMachineRunId,

//nRepProductRunId,

//nRepRollId,

//nRepSessionId,

//nRepVersionRunId,

//nRevolutionSpeedBeforeStop,

//nShiftEventId,

//nShiftId,

//nShiftSupervisorId,

nUnitId as UnitId,

nUnitTypeId as UnitTypeId,

//nUsageId,

strComment as Kommentar,

//strPictureFile,

tmEndTime,

//tmInserted,

tmTime,

Year (tmTime) as År,

Month (tmTime) as Mån,

Day (tmTime) as Dag

FROM "mwm_ct_jms".dbo.REPEVENT;

Re: double rows

Wed, 16 Nov 2011 13:50:14 GMT

Thanks! Now it works