topic Count of Distinct Records in QlikView

Count of Distinct Records

Thu, 24 May 2012 11:05:27 GMT

Dear Experts,

Kindly help me regarding the Following

PO No	PR NO	RFQ NO	Expression
10	101	1011	4000
20	201	2011	3000
30	301		2000
40		3011	5000

I am having a Pivot Table of the above type

I am making another Chart in which I am counting No.POs, No of PRs and No of RFQs

I am using following script =count (distinct (FIELD NAME)),

Result should be PO = 4 PR = 3 RFQ = 3

BUT I am getting result PO= 4 PR = 4 RFQ = 4

I think it is counting the blank field also

Kindly help on this

Thanks and Regards,

Animesh

nilesh_gangurde — Thu, 24 May 2012 11:22:35 GMT

Hi Animesh,

Please attach the sample data with qvw file

Regards,

Nilesh Gangurde

Thu, 24 May 2012 12:28:55 GMT

yes, blank will be counted as a value but null will not be counted. So, if there is a blank then you can force null.

Which will give you correct results.

Please find the attached app.

Let me know if any issue.

Ashutosh

Fri, 25 May 2012 09:04:03 GMT

Dear Ashutosh,

I was having a lot problem with this perticular Issue, it is solved with your help !!!!

Thanks a lot Sir.