Count of Missing Field Values

[qlikwiz123]

I have Excel Data and I need to find two Output fields

1. Count of all the values

2. Count of Missing values.

I tried using the CrossTable approach but the field names are not the right ones. How to achieve this in QlikView? I need to create Total and Missing Fields

[vishsaggi · Accepted solution]

My bad can you use below expr for empty values like below

= Sum(Values)

= Count({<Values = {''}>}Values)

Check attached.

[qlikwiz123]

Thank you for the quick action Let me check this one.

[jayanttibhe]

Hey buddy,

What you need is the Horizontal Calculations. So keep it simple and there is no need to add any Crosstables. Use the 'Range' functions. PFA is the solution.

Thanks

JT

[qlikwiz123]

Hi Jayant. Thank you so much. This function is awesome. We never realize how many functions we have and how to use them. Although Cross Table is a bit easier since it runs in the back-end script and you don't need to fill in the field names manually within the function, it's good to know this function exists Really appreciate your help. I just learned something new.

[jayanttibhe]

Thanks and Glad you like it:

There are following Range functions you can have a look :

Counter range functions

ClosedRangeCount

ClosedRangeMissingCount

ClosedRangeNullCount

ClosedRangeNumericCount

ClosedRangeTextCount

And Dont worry you can use them all in SCRIPT  as well.

If you are happy with the solution then close this thread marking the correct answer.