topic Re: Align tables with broken sequences - Challenge in QlikView

Align tables with broken sequences - Challenge

Fri, 28 Mar 2014 13:57:00 GMT

Greetings!

As the examples below, I have a "Table 1" production employee per day. In this table each employee, each day has an expected sequence of values to be realized. Below is an example:

I have a "Table 2" of similar officials to "Table 1", which shows the sequence of actual data. But this "Table 2" sometimes does not follow the same sequence of "Table 1".

So when next the two tables can not align the values to display the result.

I thought of a solution, and it involves comparing all values of "Table 2" of an employee / day, with all the values of "Table 1" of the same employee / day and after subtracting these values, those who have the smallest difference are correspondents table2 that are aligned with the sequence of Table 1.

Expected result:

You can do this in QlikView?

Thanks in advance!

wanderson

Re: Align tables with broken sequences - Challenge

Fri, 28 Mar 2014 16:39:02 GMT

Attached with answer. This was an interesting one.Got my gears moving.

Please check out the back-end script in the attached file for clarity.

Thanks

Re: Align tables with broken sequences - Challenge

Josh_Good — Fri, 28 Mar 2014 16:40:32 GMT

Concatenate the two tables together in the load script and give the Value in Table1 and the Value in Table 2 unique names. You will then be able to build a single chart in the QlikView UI that compare the two tables.

Re: Align tables with broken sequences - Challenge

Fri, 28 Mar 2014 17:20:51 GMT

AJ, thanks for the reply!

Already thank you for trying to understand my problem, but you went further and gave a solution!

Congratulations!

I'm "debugging" your code to understand the logic.

Just to share a little more, the real problem is because I have a scale of work provided for an employee, and the fulfillment of this scale is verified through the records of a biometric reader. In the case we have no interface between the scale system and records the biometric reader.

Once again thank you!

Wanderson

Re: Align tables with broken sequences - Challenge

Fri, 28 Mar 2014 17:22:26 GMT

Hello friend, thank you for the support and suggestion.

Wanderson