topic Re: Synthetic Keys in QlikView

Synthetic Keys

NavinReddy — Tue, 16 Sep 2014 19:20:24 GMT

Dear Experts,

I have synthetic keys in application its giving unwanted results

Budget value is different with the excel data

could some one help me to avoid synthetic keys

Please find the attachment

Thanks In Advance

Niranjan

Re: Synthetic Keys

Marcio_Campestrini — Tue, 16 Sep 2014 19:26:23 GMT

Hi Niru

You can replace the fields in tables Budget, Actuals and Forecast that is is synthetic table (Business Unit, Oscar Account Line, Year and Month) by an Key Number e.g., using AutoNumberHash128. After this, link the MasterCalendar with others tables using he same technique.

Hope I helped.

Márcio.

Re: Synthetic Keys

NavinReddy — Tue, 16 Sep 2014 19:34:07 GMT

Hi Rodrigo,

Please tell me how can i use

i don't know exactly how to use AutoNumberHash128

if you don't Mind Show me how can i do that, I can follow

Best Regards,

Niranjan

Re: Synthetic Keys

Anonymous — Tue, 16 Sep 2014 19:40:04 GMT

you can use your mastercalendar field for join Budget, Actual, Forecast tables with MasterCalendar

Month(Date) & '-' & Year(Date) AS CalendarMonthAndYear

Make a composite key, like Month & '-' & Year as CalendarMonthAndYear for each Budget, Actual, Forecast tables

And concatenate FC, AC, BU data to the one table:

Re: Re: Synthetic Keys

Marcio_Campestrini — Tue, 16 Sep 2014 19:43:36 GMT

Nirajan

The AutoNumberHash128 function works like this (extracted from Qlikview help):

AutoNumberHash128 (expression {, expression})

Computes a 128-bit hash values of the combined input expression and returns a unique value for each integer value

distinct hash encountered during script execution. this function can be used, for example, to create a representation of compact memory of a composite key.

Example:

AutoNumberHash128 (Region, Year, Month)

Use it with the fields that are common in the tables, creating one for each table.

Re: Synthetic Keys

NavinReddy — Tue, 16 Sep 2014 19:46:10 GMT

Hi Konstantins,

There are two more fields Busines Unit and Account line also

again synthetic will happen,

please find the application guide me i can do that

i am little bit confused

Best Regards,

Niranjan

Re: Synthetic Keys

NavinReddy — Tue, 16 Sep 2014 20:45:10 GMT

Thank you So much Konstantins,Grete Technique

you made my day,Thanks Again