count the null values in a Straight Table in qlikview

[#1]

Hi Every One

This Excel File I'm loading into qlikvew but in this ShopID having some Empty Cells is there i want to count the how many Null values are there in ShopID. and also Count the ShopNo Wise how many ShopId count and ShopId Null Count   ...

How to Write the Scripting to finding the NullCount  

see in below data

Regards

Sai Madhu

[Kushal_Chawda]

You will be able to see the "Correct answer" button on left bottom side of the reply

[#3]

ya i got it Thank u verymuch