Blank or NULL in Set Analysis

[qlikviewforum]

I have a field called "Area_Name". I want to set analysis to be written to Sum where the "Area_Name" is 'Blank' or 'NULL'

Sum(1)

Please help!

[jerem1234]

Maybe this:

sum({1-$<Area_Name={'=len(trim(Area_Name))<>0'}>}Value)

or

sum({1-$<Area_Name={'?*'}>}Value)

EDIT: Maybe try this as well:

sum({$-$<Area_Name={'=len(trim(Area_Name))<>0'}>}Value)

[Christian_Lauritzen]

Could you go about it differently? Is there another field that have corresponding values for all Area_Names, eg AreaID? If so, count them and subtract a count of all Area_Names where len > 0.

/Christian

[qlikviewforum]

I have attached the sample appliction? I could see only 2 records which are blank. Null records are not been shown in the chart.

Can some one please help me out with sample application? Also could you help me out on how to verify the data with raw data without set analysis?

[qlikviewforum]

Sorry unable to attache the app. Not sure where to attach it!

[qlikviewforum]

I agree this may tell whether the field has value or not. But when we create a chart based on the dimension from different table then we may not get the required results. Hope my issue is understandable!

[jagan]

HI,

Can you attach some sample application, so that it would be easier to give solution.

Regards,

Jagan.

[hallquist_nate]

In the upper right hand part of the reply window, there is an Advanced editor link.  Click on that and then at the bottom right, there is a link to attach a file.

[#9]

I think that link below will help you...

Ask null value in Set Analysis | QlikView Help, Tips & Hints

[antoniotiman]

Hi,

Try

Sum({$-<Area_Name={*}>+<Area_Name={' '}>} 1)

Regards

[MarcoWedel]

Hi qlikviewforum,

I noticed that you usually don't close your threads.

Please do so to increase the readability of this forum.

thanks

regards

Marco