I have this sql script which gives desired result in source db. I want to get the same result in qlikivew.
I have the data model setup in qlikview with the same table relationships(links/associations) as in source db.
SELECT
Date,
SUM(Total) As TotalRevenue
FROM Booking
INNER JOIN
Candidate ON Booking.Bookingid = Candidate.Candidateid
INNER JOIN
BookingTotal ON Booking.Bookingid = BookingTotal.Totalid
GROUP BY Date
ORDER BY Date desc, SUM(Total) desc
1. The above sql script contain inner join, which is not done in qlikview model for those tables. So, since qlikview model has no joins(has only associations), how can i get the same result in qlikview which i see in source db.
2. What could be the expression i can write in qlikview UI, if i am using Straight table?
I dont want to create aggregate table in qlikview script. Just a direct expression in the straight table with Date as dimension.
