Qlik Community

Ask a Question

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
Qlik Highlights 2020 Giveaway! Watch, reply and have a chance to win a $200 Amazon Gift Card! Watch Video
cancel
Showing results for 
Search instead for 
Did you mean: 
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
MVP & Luminary
MVP & Luminary

Hi,

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

Regards,

Kaushik Solanki

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".

View solution in original post

3 Replies
MVP & Luminary
MVP & Luminary

Hi,

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

Regards,

Kaushik Solanki

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".

View solution in original post

Not applicable

Thanks Kaushik Solanki for fast response!

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

Thanks and best regards,

Chanel

MVP & Luminary
MVP & Luminary

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

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".