Creating Feilds

[#1]

I have the following code :

qualify *;
unqualify [Incident ID], WO_Filter;

Workorders_Table:
LOAD [Incident ID],
     [Owned by Group],
     [WO Number],
     'Has WO' as WO_Filter
    
    
FROM
$(FactPath)BI_Workorders.QVD
(qvd);

Which creates a feild WO_Filter which has the option of 'Has WO'

How would i change this so that the WO_Filter has the option of 'Has WO' and 'Has not WO' ???

BWSBpJ3yqualify *;
unqualify [Incident ID], WO_Filter;

Workorders_Table:
LOAD [Incident ID],
     [Owned by Group],
     [WO Number],
     'Has WO' as WO_Filter
    
    
FROM
$(FactPath)BI_Workorders.QVD
(qvd);
qualify *;
unqualify [Incident ID], WO_Filter;

Workorders_Table:
LOAD [Incident ID],
     [Owned by Group],
     [WO Number],
     'Has WO' as WO_Filter
    
    
FROM
$(FactPath)BI_Workorders.QVD
(qvd);

[Jason_Michaelides]

Not sure I understand correctly, but you could try:

Workorders_Table:

LOAD

     [Incident ID],

     [Owned by Group],

     [WO Number],

     IF(IsNull([WO Number],'Has not WO','Has WO') as WO_Filter

FROM

$(FactPath)BI_Workorders.QVD

(qvd);

Hope this helps,

Jason

[#3]

it comes up with an error on the line :

IF(IsNull([WO Number] ,  'Has not WO','Has WO') as WO_Filter

where the brackets don't equal but also the ' , ' is flagged red ???

[Jason_Michaelides · Accepted solution]

Slight typo - sorry!

IF(IsNull([WO Number]),'Has not WO','Has WO') as WO_Filter

[#5]

ok thanks this works but the same as the code which i sent,

it still only gives one option so that the WO_Filter you can only select 'Has WO' :S ?

[Jason_Michaelides]

So when and why do you want 'Has not WO'?

[#7]

i want the option of having the WO_Filter to have to options which are ' Has WO ' and 'No WO' so that the information can be filtered accordinaly

[magavi_framsteg]

Hi.

Then it might just be so, that all rows in your data source indeed does have [WO Number] != null?

Kind regards

Magnus Åvitsland

BI Consultant

Framsteg Business Intelligence Corp.

[Jason_Michaelides]

As Magnus has said - my code checks for a [WO Number] and where there is one returns 'Has WO' otherwise it returns 'Has not WO'.  Should the logic be checking something different?

[magavi_framsteg]

Hi.

There are no rows without WO Nbr, is there?

You will only get to the else part of the if statement IF, and only if, the row has no WO Nbr.