Null Value Issue

[#1]

Hi All,

I have below two tables brought in Qlik Sense. Then,  I am trying to put all three columns in a simple table Chart.  .

Employee ID	Name
1	ABC
2	CD
3	EF
4	GH
5	IJ
6	KL
7	MN

Employee ID	Salary
1	100
2	200
3	300
4	400

Qlik Sense Table :

Employee ID	Name	Salary
1	ABC	100
2	CD	200
3	EF	300
4	GH	400
5	IJ
6	KL
7	MN

If the salary is null in the above table chart, i want to display as "NULL". I tried to put the expression If(IsNull(Salary),'NULL',Salary).

But this expression is not working and not giving me the expected result.

Can you please help me to fix this issue?

Thanks

NV.

[lironbaram · Accepted solution]

hi

if you want the Salary field as dimension in the table you can use this

aggr(if(count(Salary)=0,'NULL',Salary),EmployeeID)

but i suggest to use it as a measure for better performance

so you can use this expression

if(count(Salary)=0,'NULL',sum(Salary))

[shraddha_g]

try

If(len(Salary)=0,'NULL',Salary)

[#4]

Hi Nirmal,

You can try this :

=Pick((Sum(Salary)=0)+2,'Null',Sum(Salary))

[#5]

Thanks All. Its working now.