Discussion Board for collaboration related to Creating Analytics for QlikView.
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.
Anyone know why TOTAL is not in blue color in the script?
Thanks and best regards,
Go to Solution.
Total field is not available to use in script, it is allowed only in charts and front end.
Thanks Kaushik Solanki for fast response!
But do you have any idea about the workaround to show this expression?
You can use the normal Avg function with group by of the field and then you can join them together to get the values.