Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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';
Tags (1)
1 Solution

Accepted Solutions

Re: if a cell is null need to populate

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)

3 Replies
dan_sullivan
Contributor II

Re: if a cell is null need to populate

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

"Delete" as 'Measure',

Not applicable

Re: if a cell is null need to populate

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

Re: if a cell is null need to populate

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)