NULL VLAUE SIN SET ANALYSIS

[manoranjan_d]

Hi all,

i can table to get the null values for the below expression used in the chart

since its showing 0 for it

count({<ID={'*'}-{''}>}STATUS)

SO HOW TO GET THE NULL VALUES

[sunny_talwar]

May be like this:

Count({<ID -={'*'}>}STATUS)

or

Count({<ID = e({<ID = {'*'}>})>} STATUS)

[manoranjan_d]

its showing zero only

[trdandamudi]

Give a try on the below expression:

=Count( {<ID={'=Len(Trim(Status)) = 0'}>}Status)

[sunny_talwar]

Would it be possible for you to share a sample to look at?

[manoranjan_d]

hp
1
2
3
4
10
11

try with data i m not getting null value

[#7]

Hello Manoranjan,

With this data, it will be really difficult to understand the root cause of the problem. Could you give us more details of the data or send us a similar dummy data to examine?

In common scenarios, the NULL that we see are actually not NULLs, those can be

1) Blank text or

2) carriage spaces or

3) caused due to joining of tables

Thanks,

Singh

[trdandamudi]

Why don't you create a sample app and post it here, So that we can take a look and see what is the best approach. Just giving us one column of data is not sufficient.

If you are saying that you have only one column of data as provided by you above (hp) then while loading Qlikview will disregard those blank rows and it will not load it. The work around is add a second column with a dummy value in the source and it will load all the blank rows. See the attached file.. If you still think it is an issue, please post a sample file.