# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Partner

Hi,

The following expression is working for me in Qlik Sense, but I wonder if there's a way to write it shorter/cleaner:

Avg({<LinkId={'254930'}, DayName-={'Sat','Sun'}, TimePeriodIdx={'>=24'}, TimePeriodIdx={'<40'}>}TravelTime)/ 60 +

Avg({<LinkId={'254950'}, DayName-={'Sat','Sun'}, TimePeriodIdx={'>=24'}, TimePeriodIdx={'<40'}>}TravelTime)/ 60 +

Avg({<LinkId={'254920'}, DayName-={'Sat','Sun'}, TimePeriodIdx={'>=24'}, TimePeriodIdx={'<40'}>}TravelTime)/ 60 +

Avg({<LinkId={'254970'}, DayName-={'Sat','Sun'}, TimePeriodIdx={'>=24'}, TimePeriodIdx={'<40'}>}TravelTime)/ 60 +

Avg({<LinkId={'254990'}, DayName-={'Sat','Sun'}, TimePeriodIdx={'>=24'}, TimePeriodIdx={'<40'}>}TravelTime)/ 60 +

I expected to be able to do something like:

That does not work. Any idea to simplify the expression?

Thanks,

Juan

Tags (3)
1 Solution

Accepted Solutions
MVP

Hi Juan

Use Combination of Aggr & AVG

Regards

Celambarasan

2 Replies
MVP

Hi Juan

Use Combination of Aggr & AVG

Regards

Celambarasan

MVP