Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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))
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))
try
If(len(Salary)=0,'NULL',Salary)
Hi Nirmal,
You can try this :
=Pick((Sum(Salary)=0)+2,'Null',Sum(Salary))
Thanks All. Its working now.