topic Re: Null Values in Expression in QlikView

Null Values in Expression

sebastianfaust — Sat, 16 Nov 2024 00:48:20 GMT

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

Re: Null Values in Expression

sebastianfaust — Tue, 21 Apr 2020 09:33:14 GMT

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
];

Re: Null Values in Expression

Brett_Bleess — Tue, 19 May 2020 18:10:41 GMT

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/NullValue.htm?_ga=2.50153967.838796611.1589884643-1643229452.1560172143

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