topic Re: Comparing Data in QlikView

Comparing Data

Mon, 15 Aug 2011 10:16:24 GMT

Hi All,

I am new to Qlikview using Qlikview 10 personal edition.

Can anyone please let me know how to compare two different DB in qlikview.

Having 2 databases with 3 tables each with same sets of columns..

rotero — Mon, 15 Aug 2011 10:37:30 GMT

do you want to show side by side that 2 tables? for what reason may i ask...

Mon, 15 Aug 2011 12:13:06 GMT

Actually yes...

Let me explain you the exact scenario..

I am dealing with two data source x & y.

x DB has three columns x1,x2,x3 and y DB has same three columns x1, x2, x3.

Need to compare x.x1----y.x1, x.x2---y.x2, x.x3---y.x3....

Is it possible to do in qlikview.

rotero — Tue, 16 Aug 2011 00:39:04 GMT

may i know this 2 source is the same or it only have the same field name?

Or — Tue, 16 Aug 2011 03:25:17 GMT

Connect to MyDB1

// Or load from File1

Load DB1 as Source, x1, x2, x3;

SELECT * FROM myTable1;

Connect to myDB2

// Or load from File2

Load DB2 as Source, x1, x2, x3;

SELECT * FROM myTable2;

You can then add "Source" as a dimension to your table, filter on it, or do anything else you want to create comparisons.

Good luck.

Tue, 16 Aug 2011 07:12:47 GMT

Thanks .. I have done it successfully....

Tue, 16 Aug 2011 07:13:20 GMT

Thanks .. I have done it successfully....