Error on Function

Tue, 13 Apr 2010 11:04:46 GMT

Dear all, I have an error that I don't know where the problem is:

I have a variable in my QV that is called datad

I'm trying to do that function, but it shows all records and not the ones that I want

=count({$<[MESDOC]={'Month(datad)'}>} distinct [NUMUN])

If I replace function to

=count({$<[MESDOC]={'mar'}>} distinct [NUMUN])

it works perfectly

Can someone help me.

Miguel_Angel_Baeyens — Tue, 13 Apr 2010 11:24:43 GMT

Hello Jordi,

Use syntax as follows

=count({$< [MESDOC] = {'$(=Month(datad))'} >} distinct [NUMUN])

Please check that the result of the set modifier and the "month" function returns equally formatted results.

topic Error on Function in QlikView