Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

SET ANALYSIS not working in correct way

Hi All

Im using this expresion into a text object:

=Count({<STATUS_CALL = {7,8,9,10}, AÑO_FechaLlamadoOriginal = {"=year(today())"}, MES_FechaLlamadoOriginal= {"May"} >} distinct IdCallLlamadoOriginal)

the idea its not to use like this because the idiea its to take the month of the current day. So, should be something like this:

=Count({<STATUS_CALL = {7,8,9,10}, AÑO_FechaLlamadoOriginal = {"=year(today())"}, MES_FechaLlamadoOriginal= {"=month(today())"} >} distinct IdCallLlamadoOriginal)

But it isnt working...

I have tryed with month in number format, in name format and theres no way to make the MES_FechaLlamadoOriginal become equal to the Month.

Whats the problem? I dont know what its going on, really.

Thanks for All!

Germán.

1 Solution

Accepted Solutions
Miguel_Angel_Baeyens

Hi,

At a first glance, the expression should instead look like this:

Count({< STATUS_CALL = {7,8,9,10}, AÑO_FechaLlamadoOriginal = {$(=Year(Today()))}, MES_FechaLlamadoOriginal= {$(=Month(Today()))} >} distinct IdCallLlamadoOriginal)

Second, make sure that both ANO_FechaLlamadoOriginal and MES_FechaLlamadoOriginal have the same numeric format as the one returned by Year() and Month() functions.

Third, avoid when possible the use of Count Distinct, it takes longer to compute than other aggregation functions and it will slow down your charts if there are some hundreds of thousands of records.

Hope that helps.

Miguel

View solution in original post

2 Replies
Miguel_Angel_Baeyens

Hi,

At a first glance, the expression should instead look like this:

Count({< STATUS_CALL = {7,8,9,10}, AÑO_FechaLlamadoOriginal = {$(=Year(Today()))}, MES_FechaLlamadoOriginal= {$(=Month(Today()))} >} distinct IdCallLlamadoOriginal)

Second, make sure that both ANO_FechaLlamadoOriginal and MES_FechaLlamadoOriginal have the same numeric format as the one returned by Year() and Month() functions.

Third, avoid when possible the use of Count Distinct, it takes longer to compute than other aggregation functions and it will slow down your charts if there are some hundreds of thousands of records.

Hope that helps.

Miguel

Not applicable
Author

Solve!!!!

Excelent!!

Thanks a lot!