How to Create Null and Not Null Columns

[#1]

Hi,

I'm new to qlikview,

I have 12 fields ( SKU, PRODUCT_TYPE, LICENSE, BAND, etc..) each with different values or blanks.

I'm trying to create a pivot table or chart that gives me a count of all the null for each field and count of all the values for each field.

I can't seem to get this all on one table. I can have one table that gives me the nullcount for each field (done manually by writing each expression for each field). But I can't get a table that have the fields as rows and null/not null be two columns.

Can anyone help me or point me in the right direction?

Thanks a lot!@

[saumyashah90]

and so on

[saumyashah90]

or else i will say you out all the fields in on column say

Load * Inline [

Fields,

Sku,

Product_type,

band,

meter,

etc

];

[#4]

hi what but I end up getting will be something that looks like this

product type    6000

product type     500

rather than

                         null         not null

product type    6000     500

am I doint it wrong? Should those two expressions be in a single expression? if so, i'm not really sure how to do it?

[#5]

Is this feasible for a large data set?

[saumyashah90]

1)if you load  all attributes in  a column then yes it is feasible.

2)either load it from a excel to make it more error free and dynamic(no change of code).