Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
something like below should work
Date = {"=len(Date)<1"}
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.
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
i have checked no null values in the status field
No kaushik,
There are no null values found.
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
sorry wrong window its in QLiskense not Qlikview
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
When you want to show 500 then why not simple Count(Status) OR Count(Records)
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