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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
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.





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.