Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
farru_scorpio
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
dplr-rn
Partner - Master III
Partner - Master III

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
dplr-rn
Partner - Master III
Partner - Master III

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
farru_scorpio
Contributor III
Contributor III
Author

Thank you, appreciated. 🙂