Replace Null value with Placeholder Text

[JustinDallas]

Hello Everyone,

I have a data model where I have "Workers" who have records in a "PayDetail" table. This "PayDetail" table also has a linking to an "Order" table.  HOWEVER, not every PayDetail has an associated Order (i.e you pay someone for undergoing HR training or recertification). 

I'm representing this data in a Pivot table, and because of the structure, I end up with pay columns that have a "-" as their Order Number.

Is there a way I can say "if the OrderNumber is null then show Blah"?  I've tried the following statement, but it didn't change anything:

IF(ISNULL([Order Number]),'OTHER',[Order Number])

Any help is greatly appreciated.

[rittermd]

I do not believe that you can do this in a Pivot Table in Qlik Sense at this time.  At least that is what I was told a while back when I wanted to do the same thing. 

Maybe take a look at a Pivot Table extension.