Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Highlighted
Not applicable

"TOTAL" is not working in the script?

Hey community,

I found that my expression : =avg(DISTINCT total  <Route> loadfactor)

is working fine in chart.

But when I want to load this expression in script, it is not working.

Chart expression:

Script:

Anyone know why TOTAL is not in blue color in the script?

Thanks and best regards,

Chanel

1 Solution

Accepted Solutions

Re: "TOTAL" is not working in the script?

Hi,

     Total field is not available to use in script, it is allowed only in charts and front end.

Regards,

Kaushik Solanki

3 Replies

Re: "TOTAL" is not working in the script?

Hi,

     Total field is not available to use in script, it is allowed only in charts and front end.

Regards,

Kaushik Solanki

Not applicable

Re: "TOTAL" is not working in the script?

Thanks Kaushik Solanki for fast response!

But do you have any idea about the workaround to show this expression?

Thanks and best regards,

Chanel

Re: "TOTAL" is not working in the script?

Hi,

     You can use the normal Avg function with group by of the field and then you can join them together to get the values.

Regards,

Kaushik Solanki