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

"TOTAL" is not working in the script?

Thu, 21 Nov 2013 06:45:45 GMT

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

kaushiknsolanki — Thu, 21 Nov 2013 06:47:40 GMT

Hi,

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

Regards,

Kaushik Solanki

Thu, 21 Nov 2013 06:53:34 GMT

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 — Thu, 21 Nov 2013 06:55:02 GMT

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