Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
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
kaushiknsolanki
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
kaushiknsolanki
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
Author

Thanks Kaushik Solanki for fast response!

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

Thanks and best regards,

Chanel

kaushiknsolanki
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".