flags and cross tables with nulls

[#1]

I have successfully created a cross table of 'final sites' but I also need
to include data where the field is null (although I have replaced with text in
resident table) as well as 'y' (I only want to exclude where the field = 'n')

In the resident Main_Table where the field is null I have added text
values that say 'not entered'

I have used the following..

CroTables:

CrossTable (site_code,Flag,1)
LOAD
[Assignment Number],
[YCH G],
[BWM G],
[BRN G],
[LWH G],
[Velindre BRN],
[Clywedog LWH],
[Fan Gorau MCI]
Resident Main_Table;

FinalSites:
NoConcatenate LOAD * Resident
CroTables where Flag =
'y';

DROP table
CroTables;

[Gysbert_Wassenaar]

Thanks for sharing your story.

Was there any question you wanted to ask as well?

[#3]

yes its in the first bit above.... my crosstable is pulling through data where the field = 'y' but I also need to bring through null values (where data has not yet been entered) In my resident table I have used isnull function to populate the fields as 'not entered'

I want a flag where field = 'y' or 'not entered'

just not sure how to combine with above script extract?

[Gysbert_Wassenaar]

I'm afraid I don't understand.

my crosstable is pulling through data where the field = 'y'

Where does it do that? I don't see a where clause doing that in the crosstable load.

In my resident table I have used isnull function to populate the fields as 'not entered'

Which I also don't see in the script you posted. But if you did then you've already solved your problem, haven't you?

I'm sorry, but I just don't understand what you're doing, what you're trying to do, what's not working, what the source data is and what the result data should be. Perhaps these documents can help you:

• QlikCommunity Tip: How to get answers to your post?
• Its not about the answer, rather it’s about the question…

[#5]

it follows of from Load script table manipulation?!?

I havent quite got all the data I need....

In the resident table there are 3 values 'y', 'n', 'not entered'

I need the 'y' and 'not entered' to receive a flag using the crosstable function  CrossTable (site_code,Flag,1)

do i need to chage the 1 in the script? can i even do it this way

[#6]

it follows of from Load script table manipulation?!?

I havent quite got all the data I need....

In the resident table there are 3 values 'y', 'n', 'not entered'

I need the 'y' and 'not entered' to receive a flag using the crosstable function  CrossTable (site_code,Flag,1)

do i need to chage the 1 in the script? can i even do it this way