topic Values are not matching in straight table in QlikView

Values are not matching in straight table

Anonymous — Thu, 26 Mar 2015 13:47:34 GMT

hello,

I have the below data in separate straight tables for AA, BB and CC analysis for 2014

I have to get an aggregated chart to represent the totals of all 3 in total sales and individual sales for AA,BB and CC for respective destinations for 2014.

The Individual totals from the aggregated table for AA,BB and CC are not matching with the Individual tables.

I performed joins and got all the data into one single aggregated qvd and pulling that data in to reports and the numbers don't match.

Attached is my QVW.

Can someone please help me with this.

Thanks!

Re: Values are not matching in straight table

morganaaron — Thu, 26 Mar 2015 13:52:30 GMT

How are you joining the data to get the aggregated QVD? Can you post your script for generating the file?

Re: Values are not matching in straight table

Anonymous — Thu, 26 Mar 2015 14:16:08 GMT

AGG:

Load

ApplyMap('Map', [V_Code]) as [AT.TI Code],

[Hotel Travel Date] as [AT. Travel Date],

ApplyMap('Map1', [V_Code]) as [AT.CC Code],

[V_Code] as [AT. V_Code],

sum([Revenue]) as [AT. Revenue],

sum([Sales]) as [AT.Sales]

Resident [Inventory ]

Where Exists([AV_Code], [V_Code])

Group By [V_Code], [Travel Date]

;

Drop Table [Inventory];

outer Join (AGG)

LOAD

[TI Code] as [AT.TI Code],

[TI Date] as [AT. Travel Date],

[TI Sales] as [AT.TI Sales],

[TI Revenue] as [AT.TI Revenue]

FROM

[XXXXX.QVD] (qvd)

Where Exists([TI V_Code], [TI Code])

;

outer Join (AGG)

LOAD

[Travel Date] as [AT. Travel Date],

[V_ID] as [AT.CC Code],

[Sales] as [AT.CC Sales],

[Revenue] as [AT.CC Revenue]

FROM

[YYYY.QVD](qvd)

Where Exists([CC V_Code],[V_ ID]) ;

Re: Values are not matching in straight table

morganaaron — Thu, 26 Mar 2015 14:23:47 GMT

Sorry, can't really make sense of that without understanding which fields relate to the fields you're talking about in your tables! Any chance you can post your .qvw?

Re: Values are not matching in straight table

its_anandrjs — Thu, 26 Mar 2015 14:29:33 GMT

Hi,

I suggest you do Mapping first and then do the aggregation on the table and then create the SUM fields by aggregation by the field name is better way for load the table.

Hope this helps

Regards

Anand

Re: Values are not matching in straight table

Anonymous — Thu, 26 Mar 2015 15:18:19 GMT

No... It didn't work 😕

Any other suggestions?

Thanks!

Re: Values are not matching in straight table

Gabriel — Thu, 26 Mar 2015 16:35:11 GMT

Hi,

To join both table together I will do something like this

Hash128 ([AA Sales] & '|' & [BB Sales] & '|' & [CC Sales]) AS %Key_Join

In both table and this will join the table for you.

Hope this helps

Re: Values are not matching in straight table

Anonymous — Thu, 26 Mar 2015 18:54:09 GMT

Thanks for your help!

Re: Values are not matching in straight table

Gabriel — Thu, 26 Mar 2015 19:28:00 GMT

DDid that help?

please mark as helpful or answer

Re: Values are not matching in straight table

Anonymous — Thu, 26 Mar 2015 20:03:53 GMT

I still have the same issue...

I used apply map and outer join to get data into my Aggregated QVD.

The values still don't match or not even close to the values from production.

You need more information to help me with this issue?

Re: Values are not matching in straight table

Anonymous — Thu, 26 Mar 2015 20:05:49 GMT

when i make any changes i see this issue...

Attached qvw in the initial post, can someone please help me with this asap...

Thanks!

Re: Values are not matching in straight table

Anonymous — Fri, 27 Mar 2015 15:26:45 GMT

I tried group by on joining tables and it worked!!

Thank you all for your time!