I'm new in qlickview, and want to make some comparsion. So I have two tables with the same columns names with different values and I want to compare those values (probably i have to do this by if statement) and if values do not match i want to show something like error message and then count those error to show (for example on a chart )the differences between values in columns.
Great Day. I think the most easy way to compare dates are, Join this Two tables. after join, compares with if loading again the table with resident command. Follow de example: Table A, Table B; left join(A) LOAD * Resident B; drop table B;
noconcatenate TempA: LOAD *,if(DateA>DateB,'UHUL','NO') as Comparison RESIDENT A; drop table A; Rename Table TempA to A;