Qlik Community

Community Corner

Discussion board for questions about the Qlik Community, its features, sharing information, general discussions and even some fun. This is for both new and longtime community members. Everyone is welcome!

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Finding Lowest and Highest Average Ticket Price of the Day

Hello Experts,

I have attached one excel file the idea is to find our lowest and highest average ticket price of the day. Please see excel file for better understanding.

I will appreciate your quick help.

Labels (1)
1 Solution

Accepted Solutions
Partner
Partner

Maybe i am misunderstanding the issue. it seems straight forward.

Date as dimension and rest as expressions. see below output

DATESum(FARE*COUNT)Sum(COUNT)Avg(FARE)Min(FARE)Max(FARE)
 11327129445801,340
01/10/2019268038935801,150
02/10/2019432758656581,125
03/10/2019432041,0807801,340

View solution in original post

2 Replies
Partner
Partner

Maybe i am misunderstanding the issue. it seems straight forward.

Date as dimension and rest as expressions. see below output

DATESum(FARE*COUNT)Sum(COUNT)Avg(FARE)Min(FARE)Max(FARE)
 11327129445801,340
01/10/2019268038935801,150
02/10/2019432758656581,125
03/10/2019432041,0807801,340

View solution in original post

Highlighted
Contributor III
Contributor III

Thank you, appreciated. 🙂