Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Error on Function

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.





Labels (1)
1 Solution

Accepted Solutions
Miguel_Angel_Baeyens

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.

View solution in original post

1 Reply
Miguel_Angel_Baeyens

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.