topic Re: Calculating off Concatenated table in QlikView

Calculating off Concatenated table

Fri, 13 Mar 2015 14:55:26 GMT

Hi,

I have the need to create calculations off of different fields on a table that has been built by concatenating many tables into one. I mainly did this because I needed the date fields to be able to be filtered off the entire document.

If you see the below images there are two tables. The top one is a straight able that shows some calculated values (expressions in the header) and the second image is just a table box. Can someone help me understand why the Table box shows the correct value but if I put a Sum in front of the value it gives me a number that doesn't make any sense.

Straight Table with Sums

Table Box

Re: Calculating off Concatenated table

JonnyPoole — Fri, 13 Mar 2015 15:46:38 GMT

the numbers in the straight table are inflated 26400 times ( 660,000/25 = 26400 etc...)

Is that the number of records in the concatenated table ?

Once you have the full concatenated table, it can be helpful to load dimensions with a centralized fact table from that main table to create a star schema (and drop the original concat table). It can prevent extra counting of records.

Thats only a guess, a look at your QVW would help too.

Re: Calculating off Concatenated table

Fri, 13 Mar 2015 17:22:16 GMT

Thank you. Off of your comment I think I figured it out. For whatever reason it took the numbers and repopulated them into other fields where it shouldn't have. I will give your suggestion a try and see if I can't make sense of this. Thanks for the help.