expression for sql script

surajap123 — Tue, 13 May 2014 11:10:04 GMT

Hi All,

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.

topic expression for sql script in QlikView

expression for sql script