topic count(expression) doesn't work in QlikView

count(expression) doesn't work

Tue, 08 Mar 2011 15:04:36 GMT

Hi,

I've got an expression :

=if(min({1} total <PAT_Ipp> MOD_Date_debut)>=date_nvx_pat,PAT_Ipp)

'PAT_ipp' is a field,'MOD_Date_debut' is a field, 'date_nvx_pat' is a variable ('date_nvx_pat'=min(total{$} calendrier_date))

This expression works fine, i manage to see the field 'PAT_Ipp'.

But when I want to count this field PAT_Ipp:

=count(distinct if(min({1} total <PAT_Ipp> MOD_Date_debut)>=date_nvx_pat,PAT_Ipp) )

It doesn't work and the expression editor tells me 'error in expression'. Can you tell me why ??? Because I have similar expressions (but with no variable) which works fine.

Thanks

count(expression) doesn't work

fosuzuki — Tue, 08 Mar 2011 15:56:19 GMT

Hi,

i think that you need to expand your variable with the dollar sign:

=count(distinct if(min({1} total <PAT_Ipp> MOD_Date_debut)>=$(date_nvx_pat),PAT_Ipp) )

Regards

count(expression) doesn't work

Wed, 09 Mar 2011 11:47:07 GMT

Thanks for your help,

I tried this with no success. I tried without the variable ('calendrier_date' is a field) :

=if(min({1} total <PAT_Ipp> MOD_Date_debut)>=min(total{$} calendrier_date),PAT_Ipp) WORKS

=count(distinct if(min({1} total <PAT_Ipp> MOD_Date_debut)>=min(total{$} calendrier_date),PAT_Ipp) ) DOESN'T WORK (still same error message)

An idea ??

count(expression) doesn't work

Mon, 14 Mar 2011 08:59:35 GMT

I' also tried this with no success :

=count({$<Min({1} total <PAT_Ipp> MOD_Date_debut)>=min(total{$} calendrier_date)>} PAT_Ipp)

can someone help me plz ?? thanks

count(expression) doesn't work

fosuzuki — Sat, 02 Apr 2011 12:17:57 GMT

Hi, sorry I forgot to follow up this thread.

The possible problem with yout expression is that you are nesting a min() inside a count() . You cannot directly nest aggregation functions. You have to use the aggr function 'between' them. Something like Count(Aggr(Min(...)..)).

Hope this helps.

Regards,

Fernando