Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

robsonenascimen
New Contributor II

how display data from a X field in a Y (Null) field.

Hi, how can I display data from an X field in a Y field. Could someone help me with this question?

I have items from the Y field that are as Nulls in the database, I would like to represent these Null fields with the X field information.

The fields are in different tables, but there is a relationship between tables.

IsNull_TCOType.jpg

Follows structure of tables;

ViewTimesheet:
LOAD TaskID as [ISR Number], Upper (CDSID) as CDSID, Hours,
Year (WorkDate) as Year, 'Q' & ceil (Month (WorkDate) / 3) as Quarter,
Month (WorkDate) as Month, Title;
SQL SELECT CDSID, Hours, TaskID, Title, WorkDate
FROM "WebISR_Reports" .dbo.viewTimesheet
WHERE [WorkDate]> = '2015-01-01';

Join

Variation_Log:

LOAD "ITMSFunction_ID" as "Function_ID", "Log_Number" as [ISR Number],
     IF (Type = 'EN', 'Enhancement (EN)',
     IF (Type = 'ND', 'New Development (ND)',
     IF (Type = 'PS', 'Production Support (PS)')) as [TCO Type];
SQL SELECT "ITMSFunction_ID", "Log_Number", Type
FROM "WebISR_Reports" .dbo. "Variation_Log"
WHERE "ITMSFunction_ID"> '0';

Example I have a Table that contains the [TCO Type] field, and some information from these fields appears as Null, but in other Table I have the Title field that contains the information I need.

See the details of the fields in the images.

Thanks for attention

7 Replies
trdandamudi
Honored Contributor

Re: how display data from a X field in a Y (Null) field.

I am not very clear about the requirement but please take a look at Mapping load... and that should help you....

Highlighted
Partner
Partner

Re: how display data from a X field in a Y (Null) field.

Hi Robson,

You can try something like this:

ViewTimesheet:

LOAD TaskID as [ISR Number], Upper (CDSID) as CDSID, Hours,

Year (WorkDate) as Year, 'Q' & ceil (Month (WorkDate) / 3) as Quarter,

Month (WorkDate) as Month, Title;

SQL SELECT CDSID, Hours, TaskID, Title, WorkDate

FROM "WebISR_Reports" .dbo.viewTimesheet

WHERE [WorkDate]> = '2015-01-01';

Map_ISRNumber:

Mapping Load

[ISR Number],

Title

Resident

ViewTimesheet;

Join (ViewTimesheet)

Variation_Log:

LOAD "ITMSFunction_ID" as "Function_ID", "Log_Number" as [ISR Number],

     IF (Type = 'EN', 'Enhancement (EN)',

     IF (Type = 'ND', 'New Development (ND)',

     IF (Type = 'PS', 'Production Support (PS)',

     ApplyMap('Map_ISRNumber', "Log_Number",'Unknown')

     ))) as [TCO Type];

SQL SELECT "ITMSFunction_ID", "Log_Number", Type

FROM "WebISR_Reports" .dbo. "Variation_Log"

WHERE "ITMSFunction_ID"> '0';

Thanks,

Shun

robsonenascimen
New Contributor II

Re: how display data from a X field in a Y (Null) field.

Hi Shun,

It's almost this, let me explain better.

I need to display in the [TCO Type] field, the information that is in the Title in yellow, only when the value is null it should fetch the information in the Title field. I have the conditions below that are null in the TCO Type, and I would like to Obtain the information in the table, the information separated by Title

IsNull_TCOType3.jpg

TaskID, Title
10, Non-ISR Work, General
20, Non-ISR Work, Customer Relationship Management
25, Non-ISR Work, Training
110, Non Working Hours - Vacation
1020, Non Working Hours - Other (Optional)
1000, Non Working Hours - Sick
1015, Non Working Hours - Training

Thanks for your Help and attention

Robson

Partner
Partner

Re: how display data from a X field in a Y (Null) field.

Hi Robson,

For me to look further I will need to obtain a sample data.

But you should be able to use ISR_number in the front end as a dimension, to separate those values if the TCO type is null.

satishsure
New Contributor

Re: how display data from a X field in a Y (Null) field.

Hi Robson..If you could provide both tables sample data.so that anyone can try reproduce your requirement and get the appropriate solution.

robsonenascimen
New Contributor II

Re: how display data from a X field in a Y (Null) field.

Hi Shun,

Ok, I can send for you the .QVW file without the requested changes.

Please, if possible, inform me an email.

Thanks

Robson

robsonenascimen
New Contributor II

Re: how display data from a X field in a Y (Null) field.

Hi Satish,

Ok, I can send for you the .QVW.

Please, if possible, inform me an email.

Thanks

Robson