Null value issue

[#1]

Hi

I have a count of values in list box is 20 but it is showing count as 21 in header. i have a Data with null but I compressed in script using where condition. even though it is  showing as 21 instead of 20.when I count manually there are only 20.

Please help on this.

Thanks

[satishkurra]

You at-least need to provide some sample data or app if possible.

[swuehl]

Not really sure I do understand your issue.

Could you post some more details, like screenshots, or better, a small sample QVW?

[#4]

please find the attached image.

Actually I have 22 values but in header it is showing 23 instead of 22.

[#5]

Hi satish

Thanks for quick response.

please find the below attached image

[sunny_talwar]

What is the expression you are using to count in the header?

[satishkurra]

As you have only few records, please share the data file and expression using

[#8]

Hi sunny

Below line is the expression I am using as you suggested yesterday.

='list of Diff' & '-' & Count({<Flag = {'Diff'}>}key)

[sunny_talwar · Accepted solution]

What if you add DISTINCT in there

Count(DISTINCT {<Flag = {'Diff'}>}key)

[swuehl]

Maybe you have duplicate key records?

='list of Diff' & '-' & Count(DISTINCT {<Flag = {'Diff'}>}key)