Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Null value issue

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

1 Solution

Accepted Solutions
sunny_talwar

What if you add DISTINCT in there

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

View solution in original post

13 Replies
satishkurra
Specialist II
Specialist II

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

swuehl
MVP
MVP

Not really sure I do understand your issue.

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

Not applicable
Author

please find the attached image.

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

Not applicable
Author

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
Specialist II
Specialist II

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

Not applicable
Author

Hi sunny

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

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

sunny_talwar

What if you add DISTINCT in there

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

View solution in original post

swuehl
MVP
MVP

Maybe you have duplicate key records?

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