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

Problems with Gauge Chart, Set Analysis and Networkdays

Hi Guys,

I'm problem with a formula into a gauge chart, here is:

=avg ( {$< EstadoReport = {"Em Curso","Em Contacto","Fecho Sucesso","Fecho Insucesso"},
Opty_Creat_Dt = {">=$(#=vInicio)<=$(#=vFim)"} > } (networkdays(date(Opty_Creat_Dt),date(Tlcl_Answer_Dt),$(allholidays))) )

I want to know the average in the last 90 days but using the networkdays.

"allholidays" is a variable with all holidays in my country.

This formula give "no data value" but I don't know why.

If I use:

=avg ( {$< EstadoReport = {"Em Curso","Em Contacto","Fecho Sucesso","Fecho Insucesso"},
Opty_Creat_Dt = {">=$(#=vInicio)<=$(#=vFim)"} > } ALL (networkdays(date(Opty_Creat_Dt),date(Tlcl_Answer_Dt),$(allholidays))) )

...works fine.

But I cannot use ALL.......

What I can to do?

Anybody can help me, please?

Thanks,

Rodrigo.

15 Replies
Not applicable
Author

Hi,

I did, but it runs the same.

= avg ( {$< EstadoReport = {"Em Curso","Em Contacto","Fecho Sucesso","Fecho Insucesso"},

Opty_Creat_Dt = {">=$(#vInicio)<=$(#vFim)"} > } (SLADiff) )

SLADiff is the field created in load script.

But... there is no data value.

If I use:

= avg ( {$< EstadoReport = {"Em Curso","Em Contacto","Fecho Sucesso","Fecho Insucesso"},

Opty_Creat_Dt = {">=$(#vInicio)<=$(#vFim)"} > } ALL (SLADiff) )

works fine, but I cannot use ALL in that expression...

I really dont know what to do.

Thanks,

Rodrigo.

kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

   Can you please provide the qvw file.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
erichshiino
Partner - Master
Partner - Master

Hi, Rodrigo.

Do you know why it works with All? This would ignore selections and dimensions in a chart?

Are you using any dimension on the gauge?

Does it work with the 1 instead of $?

avg ( {1< EstadoReport = {"Em Curso","Em Contacto","Fecho Sucesso","Fecho Insucesso"},

Opty_Creat_Dt = {">=$(#vInicio)<=$(#vFim)"} > } (SLADiff) )

(... a lot of questions to try to better understand your problem)

Regards,

Erich

Not applicable
Author

Hi,

I cannot send the file now because there is a lot of customer's data.

But..... I 'd tried a test...

If I use the expression without the agregation of dates in set analysis, it works fine:

= avg ( {$< EstadoReport = {"Em Curso","Em Contacto","Fecho Sucesso","Fecho Insucesso"}/> }

(networkdays(date(Opty_Creat_Dt),date(Tlcl_Answer_Dt),$(allholidays))) )

I think the problem is in the agregation

Opty_Creat_Dt = {">=$(#vInicio)<=$(#vFim)"}

However I need to used that to agregate the status (EstadoReport field) and agregate the last 90 days.

What can I do??

Thanks,

Rodrigo.

Not applicable
Author

Hi Erich,

I'm not using dimensions.

I'm just using that expression.

I need to know the average count of days (it is a diference date between Update Date and Creation Date), agregate by Status and las 90 days.

But I really dont know why does not work without ALL function....

Do you have an idea?

Thanks,

Rodrigo.

Not applicable
Author

Friends!

I won this chalenge.

Thanks Kaushik and Erick.

Thank you for your support.

Best regards,

Rodrigo.