Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

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
MVP
MVP

Re: SET ANALYSIS not working in correct way

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

2 Replies
MVP
MVP

Re: SET ANALYSIS not working in correct way

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

SET ANALYSIS not working in correct way

Solve!!!!

Excelent!!

Thanks a lot!

Community Browser