Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Paknanarn23
Creator II
Creator II

How do I calculate null values?

I want to calculate the null values ​​to get the following result

Paknanarn23_0-1675309953212.png

What do I need to do? I tried Nullcount(field) but it only counts numbers. I want to be sum

 

Labels (4)
7 Replies
sidhiq91
Specialist II
Specialist II

@Paknanarn23  We are not able to understand your complete requirement. Could you please post some sample data and the expected output?

Paknanarn23
Creator II
Creator II
Author

@sidhiq91  
I have the following information 

Paknanarn23_0-1675313362068.png

In my data table there are n/a values, so I would like to extract the sum of n/a like this.

Paknanarn23_1-1675313426364.png

 

Which if I use the nullcount formula, it's counting numbers which is not what I want

sidhiq91
Specialist II
Specialist II

@Paknanarn23  Please see the below code and let me know if it helps.

NoConcatenate
Temp:
Load Shift,
if(isnull(EmptyIsNull(MCDesc)),'No Value') as MCDesc,
Total

inline [
Shift,MCDesc,Total
Afternoon,,875
Day,,854
Night,,94
];

Exit Script;

 

Paknanarn23
Creator II
Creator II
Author


Can I put this code in expressions

Paknanarn23
Creator II
Creator II
Author

The total value is a value that changes every day.

sidhiq91
Specialist II
Specialist II

@Paknanarn23  The total value should not be a problem if it changes everyday. You can try the  expression in UI too.

Paknanarn23
Creator II
Creator II
Author

I tried to do it but the value still doesn't come out.

2023_02_02_16_39_47_10.10.99.155_Remote_Desktop_Connection.png