Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

sureshqv
Esteemed Contributor III

Missig count

hi all,

I have small issue

3expressions i have like below

=count(records)      500

=count({<Status={'complete','incomplete'} >}Record)      400

=count({<Status -={'complete','incomplete'} >}Record)     95

here is the issue  comes

when i club the exp 2&3   i need to get 500 records but my result showing 495 only.... where am missing  remaining 5 recors?

can anyone help me out on this?

Best

chanty

Tags (1)
1 Solution

Accepted Solutions
vinieme12
Esteemed Contributor II

Re: Missig count

something like below should work

Date = {"=len(Date)<1"}

14 Replies
MVP
MVP

Re: Missig count

The missing records have nulls for Status. Set expressions work like selections in the front end and do not select null values, just like you can't select null values in a list box.

Re: Missig count

Hi,

It is because your status field contains the null value.

You can find using this statement in script.

LOad *, if(Isnull(Status),1,0) as Flag From xyz;

Regards,

Kaushik Solanki

sureshqv
Esteemed Contributor III

Re: Missig count

i have checked no null values in the status field

sureshqv
Esteemed Contributor III

Re: Missig count

No kaushik,

There are no null values found.

Re: Missig count

Do one thing.

Create a list box of Status field and in Properties->General Tab-> Click on Show Frequency.

You will see how many records are there for each value of the field. That will tell u where the problem is.

Regards,

Kaushik Solanki

sureshqv
Esteemed Contributor III

Re: Missig count

sorry wrong window its in QLiskense not Qlikview

Re: Missig count

In Qlik Sense you can create a straight table, put status as dimension and Count(Status) as expression and see the values.

Regards,

Kaushik Solanki

Re: Missig count

When you want to show 500 then why not simple Count(Status) OR Count(Records)

vinieme12
Esteemed Contributor II

Re: Missig count

If you don't have null's then they may be spaces or enter characters , have you checked for such issues?

Do this for your Status Field during load

Pick(Wildmatch(Status,'Complete','Incomplete')+1,'NA','Complete','Incomplete') as Status 

This will replace any values other than Complete or Incomplete