I would like to know how can I achieve this SQL query in Qlikview?
SELECT *FROM tab1 a, tab2 bwhere a.AY=b.A_Yand a.Sem=b.SEMand a.CC=b.C_CDE& "-" &U_Cand b.ROLE='XXX'and a.FID <> b.O_PNO;
LOAD * ;
FROM tab1 a, tab2 b
and a.CC=b.C_CDE& "-" &U_C
and a.FID <> b.O_PNO;
My source tab1 and tab2 are actually exported into excel spreadsheet. Can the above still achieve the same result?
Yes of course. Use the wizard to get something like the below, then add the WHERE clause before the last ;
FROM (Data.xls blah blah blah)
I put my data into access database. When I tried the recommended solution 1, it gave me an error:SQL##f - SqlState: 07001, ErrorCode: 4294964286, ErrorMsg: [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.
Can you post your qvw and access DB?
Are you sure you have the ODBC connection set up correctly?
Retrieving data ...