topic Re: RE:Other than Distinct? in QlikView

RE:Other than Distinct?

Chanty4u — Sat, 13 Feb 2016 12:24:35 GMT

hi all,

I have small doubt.

Is there any other function to get the distinct count output?

Ex:count(distinct sales)=100

the sam eoutput shud come witout usng distinct?

Any suggestions?

Thanks In advance.

Re: RE:Other than Distinct?

sunny_talwar — Sat, 13 Feb 2016 12:28:07 GMT

Have not tested, but may be this:

Count(Aggr(Count(Sales), Sales))

Re: RE:Other than Distinct?

sunny_talwar — Sat, 13 Feb 2016 12:32:15 GMT

Sample:

Table:

LOAD * Inline [

Sales

];

Re: RE:Other than Distinct?

swuehl — Sat, 13 Feb 2016 12:39:35 GMT

What is your doubt concerning using

Count(Distinct FieldName)

What Sunny suggested works, but I see no advantage in using this?

A common practice is to create a field CounterOfFieldName in your dimensional table (that holds the distinct values of FieldName) just containing 1, then do a

=Sum(CounterOfFieldName)

Re: RE:Other than Distinct?

Chanty4u — Sat, 13 Feb 2016 12:44:34 GMT

thnx sunny and swuehl.....

no use of that just want to know ...

and i want to get count and with in that no duplicates? how cn i?

Re: RE:Other than Distinct?

sunny_talwar — Sat, 13 Feb 2016 12:46:28 GMT

Count(DISTINCT ...) would be the most efficient way to do it I believe.

Re: RE:Other than Distinct?

Chanty4u — Sat, 13 Feb 2016 12:48:36 GMT

ohhh is it? can i get usng rowno() or iter() function?

if yes explain bro?

Re: RE:Other than Distinct?

sunny_talwar — Sat, 13 Feb 2016 12:50:09 GMT

In the script? front end chart? front end text box object?

Re: RE:Other than Distinct?

Chanty4u — Sat, 13 Feb 2016 12:51:57 GMT

how to do in script and frnt end aswell?

Re: RE:Other than Distinct?

swuehl — Sat, 13 Feb 2016 13:37:06 GMT

In the script,

You can use

LOAD Count( DISTINCT FieldName) AS DistinctFieldNameCount

RESIDENT YourTable;

[Note: That will count only FieldName in one table, so if FieldName is a key, this may differ from the other methods]

Or as field function:

Let vDistinctFieldName = FieldValueCount( 'FieldName');

If you create a straight table chart with dimension FieldName,

=RowNo(TOTAL)

will return the distinct count as well in each line.

There probably more methods to get someway or another a distinct count, but the common way is just a

=Count( Distinct FieldName)

Re: RE:Other than Distinct?

Chanty4u — Sun, 14 Feb 2016 07:25:36 GMT

thnk u sunny and swehl...........for ur infrmatn.

Thanks

Suresh