Null Values in Expression

[sebastianfaust]

Hi all, 

i have this pivot table:

i want to have a 0 instead of the dash.

how can i do that?

thanks and regards

[sebastianfaust]

this is the demo code:

Products:
load
*
inline
[
productID , productName
A, Apple
B, Banana
C, Car
D, Doll
E, Egg
];

Revenue:
load
*
inline
[
Customer, productID , revenue
Amazon, A, 10
Amazon, D, 20
Amazon, C, 30
Lidl, E, 30
];

[Brett_Bleess]

Check out the following Help link, believe that should get you on the right track, use the first function to specify the fields you want to include and in the second function you specify what you wish to replace Null with when encountered, so '0' in your case I believe.

https://help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/Scripting/ValueHandlingVariables...

The following Design Blog post may be of some further help too:

https://community.qlik.com/t5/Qlik-Design-Blog/NULL-The-Invisible-Nothing/ba-p/1467674

Regards,
Brett