topic Re: Distinct Total Count in Statistics Box in QlikView

Distinct Total Count in Statistics Box

harleen_singh — Wed, 23 Feb 2011 08:39:35 GMT

Hello,

I want to know how to Display Distinct count in Statistics Box in place of 'Total Count' function.

Total Count function always count all the rows but i want to count only Distinct values.

Thanks

Lavi

AW:Distinct Total Count in Statistics Box

Wed, 23 Feb 2011 09:10:34 GMT

Hello Lavi,

had the same demand a few weeks ago, but I didn't find any resolution. The availible functions are hard wired and thats it. But perhaps this little workaround will help you: I used the help text to show the count distinct through an expression.

Regards, Roland

AW:Distinct Total Count in Statistics Box

harleen_singh — Wed, 23 Feb 2011 11:26:37 GMT

Roland,

thanks for ur response. Well can u tell me where is this help text?? Is it inside statistics box or in other place?

Regards

Lavi

AW:Re: AW:Distinct Total Count in Statistics Box

Wed, 23 Feb 2011 14:21:25 GMT

Hi Lavi,

no problem. Go to Statistics Box properties --> Caption Tab --> in the lower right corner you will find help text inputfield. My field is called VQuartal:

='VQuartal dist.: ' & count(distinct VQuartal)

Re: Distinct Total Count in Statistics Box

Anonymous — Thu, 16 Jun 2016 08:40:32 GMT

Hi Roland,

I tried your idea and it worked successfully. I have attached screen shot also. But, is there any way to get into the Statistics Box witout getting the information into "HELP" properties of Statistics Box. Please Help me. Thanks in advance.

Re: Distinct Total Count in Statistics Box

Wed, 18 Jan 2017 13:14:10 GMT

Hi there

it doesnt work with me ? could you please help here is a sample from the field data

CMKJ19

CVTN03

CWLV03

CWZR17

CXZH06

CZSM05

DBGQ09

DBVT09

DBSS06

DCGH19

DCPN06

DCTV06

DGRL19

Re: Distinct Total Count in Statistics Box

josephinetedesc — Thu, 19 Jan 2017 00:08:25 GMT

I found I needed to use a text box to do a distinct count ...

Re: Distinct Total Count in Statistics Box

Thu, 19 Jan 2017 14:04:30 GMT

But i ve tried that as well same results

Re: Distinct Total Count in Statistics Box

josephinetedesc — Thu, 19 Jan 2017 22:39:38 GMT

Hi Eman

this might help.

Because (infoWanted) is a text field then all the other statistical values are n/a

so Text count and Total count are ok - I am not sure what Missing count means.

the text box has:

=count(Distinct(infoWanted)) & ' this is the count of distinct ....'

Re: Distinct Total Count in Statistics Box

Fri, 20 Jan 2017 06:58:39 GMT

Thank You so much Jo i got it now.

Appreciate your help.

Thanks

Eman