Missig count

[Chanty4u]

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

[jonathandienst]

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.

[kaushiknsolanki]

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

[Chanty4u]

i have checked no null values in the status field

[Chanty4u]

No kaushik,

There are no null values found.

[kaushiknsolanki]

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

[Chanty4u]

sorry wrong window its in QLiskense not Qlikview

[kaushiknsolanki]

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

[Anil_Babu_Samineni]

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

[vinieme12]

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