topic NODISTINCT in QlikView

NODISTINCT

Mon, 30 Aug 2010 11:28:20 GMT

Hello,

I'm trying to get a nodistinct results but I get the wrong results when I use the following formulas:

=Count(if([Date de début]<=Date_max and [Date de début]>=Date_min,[Date de début])) => I get the distinct count

=Count(nodistinct if([Date de début]<=Date_max and [Date de début]>=Date_min,[Date de début])) => I get an empty column (no values)

Thanks for your help!

mel

NODISTINCT

Miguel_Angel_Baeyens — Mon, 30 Aug 2010 11:49:25 GMT

Hello Mel,

As far as I know, NODISTINCT clause is only allowed in the aggr() function, as Count() without modifiers returns the number of records where the field specified is in.

You may try with a different field that [Date de début] just to check that your conditional is returning more than one possible values for each comparison.

Hope that helps

NODISTINCT

Or — Mon, 30 Aug 2010 12:39:19 GMT

Try:

sum(if([Date de début]<=Date_max and [Date de début]>=Date_min,1))

Summing 1 for each relevant value is the same as counting non-distinct values, though I'll admit it doesn't read as cleanly.

NODISTINCT

Tue, 31 Aug 2010 12:50:52 GMT

Hello and thank you for your answers.

I tried doing the count by another field but without success. The results are always distinct. I'm fearing that it might have to do something related to my schema/modelisation...

NODISTINCT

Tue, 31 Aug 2010 12:54:17 GMT

Thanks for your answer.

I tried your suggested formula but the results are the same ...