topic Re: Null value issue in QlikView

Null value issue

Wed, 13 Apr 2016 18:45:14 GMT

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

Re: Null value issue

satishkurra — Wed, 13 Apr 2016 18:46:33 GMT

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

Re: Null value issue

swuehl — Wed, 13 Apr 2016 18:47:36 GMT

Not really sure I do understand your issue.

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

Re: Null value issue

Wed, 13 Apr 2016 18:53:36 GMT

please find the attached image.

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

Re: Null value issue

Wed, 13 Apr 2016 18:54:50 GMT

Hi satish

Thanks for quick response.

please find the below attached image

Re: Null value issue

sunny_talwar — Wed, 13 Apr 2016 18:56:03 GMT

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

Re: Null value issue

satishkurra — Wed, 13 Apr 2016 18:57:26 GMT

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

Re: Null value issue

Wed, 13 Apr 2016 18:59:22 GMT

Hi sunny

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

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

Re: Null value issue

sunny_talwar — Wed, 13 Apr 2016 19:03:30 GMT

What if you add DISTINCT in there

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

Re: Null value issue

swuehl — Wed, 13 Apr 2016 19:04:39 GMT

Maybe you have duplicate key records?

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

Re: Null value issue

Wed, 13 Apr 2016 19:09:20 GMT

Attached Image is with null in Data. I filtered in Scripting using where condition like

where key>0;

but still in list box it is showing

Re: Null value issue

sunny_talwar — Wed, 13 Apr 2016 19:10:08 GMT

Try this where statement:

Where If(Len(Trim(key)) > 0;

Re: Null value issue

swuehl — Wed, 13 Apr 2016 19:16:04 GMT

Sorry I can't see your attached image.

If you want to filter NULL in your where clause, follow Sunny's suggestion, though I still havent't seen something that points to a NULL issue in the information you've posted so far (which you can read as: please post more details)

Re: Null value issue

Wed, 13 Apr 2016 19:16:43 GMT

Thanks sunny and swuehl

its perfect now

Problem is because of Duplicates