topic Re: How do I calculate null values? in QlikView

How do I calculate null values?

Paknanarn23 — Fri, 15 Nov 2024 21:50:35 GMT

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

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

sidhiq91 — Thu, 02 Feb 2023 04:32:12 GMT

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

Paknanarn23 — Thu, 02 Feb 2023 04:52:14 GMT

@sidhiq91
I have the following information

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

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

sidhiq91 — Thu, 02 Feb 2023 05:54:17 GMT

@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 — Thu, 02 Feb 2023 06:35:15 GMT

Can I put this code in expressions

Paknanarn23 — Thu, 02 Feb 2023 06:38:16 GMT

The total value is a value that changes every day.

sidhiq91 — Thu, 02 Feb 2023 09:34:40 GMT

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

Paknanarn23 — Thu, 02 Feb 2023 09:41:31 GMT

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