Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

if a cell is null need to populate

I am combining the two tables below, and linking it to a third table.

The two tables has a field I created in the load call Measure.

1. 'ProfileOnly' as Measure,

2. 'NewRx' as Measure,

The third table does not have this field.

How can I populate the null cell below with the word Delete?

In my pivot table see the blank cell above NewRX.

DATA LOAD

   

LIB CONNECT TO 'pharmoresql
LOAD FacID,
'0' as TransType,
ProfileOnly as Type,
'ProfileOnly' as Measure,
eRxMsgID;
SQL SELECT FacID,
ProfileOnly,
eRxMsgID
FROM Pat.dbo.Reorders
Where ProfileOnly <> '0';
LOAD
FacID,
TransType,
NewRx as Type,
'NewRx' as Measure,
eRxMsgID;
SQL SELECT NewRx,
TransType,
FacID,
eRxMsgID
FROM Rx.dbo.HRxs
Where NewRx <> '0'
and TransType <> 'Q'
and TransType <> 'R';
1 Solution

Accepted Solutions
rubenmarin

Hi Robert, those records seems the ones that has no relation with the values loaded in the queries, you can change this in script but you'll need to prive more info about the first dimension and the rest or model.

Other easy solution can be using a calculated dimension for Measure:

If(IsNull(Measure), 'Delete', Measure)

View solution in original post

3 Replies
dan_sullivan
Creator II
Creator II

in the script for the third table just put in a line of code:

"Delete" as 'Measure',

Not applicable
Author

I tried that and it removes the other two cell names.

rubenmarin

Hi Robert, those records seems the ones that has no relation with the values loaded in the queries, you can change this in script but you'll need to prive more info about the first dimension and the rest or model.

Other easy solution can be using a calculated dimension for Measure:

If(IsNull(Measure), 'Delete', Measure)