topic Re: Autonumber in QlikView

Autonumber

Wed, 17 Jun 2015 11:21:48 GMT

Hi Experts,

i have the following table.

BranchCal:

LOAD BRCODE,

DECDDT,

Date(DECDDT, 'DD/MM/YYYY') as DATE,

Month(DECDDT) as MONTH,

MonthName(DECDDT) as MonthYear,

Year(DECDDT) as YEAR,

DAYS,

AutoNumber(BRCODE&'-'&DECDDT) as Key

FROM

QVD\BranchCal.qvd

(qvd);

in the above script i need to do Autonumber for MonthYear field also.

How can i do this.

pls helpppp....

Re: Autonumber

Anonymous — Wed, 17 Jun 2015 11:30:15 GMT

What do you hope to achieve by doing Autonumber for MonthYear field ?

It will already be stored a number and not have many distinct values.

Re: Autonumber

Wed, 17 Jun 2015 11:31:24 GMT

just want to do reference table to avoid synthetic key.

plssssss helppp

Re: Autonumber

jonathandienst — Wed, 17 Jun 2015 11:43:32 GMT

Not sure what advantages this will offer you, but to autonumber multiple sequences, you can use the optional series name parameter:

AutoNumber(MonthName(DECDDT), 'MonthYear') As MYKey,

AutoNumber(BRCODE&'-'&DECDDT, 'BrCode') as Key

Re: Autonumber

jonathandienst — Wed, 17 Jun 2015 11:47:43 GMT

If you mean composite containing all 3 fields:

AutoNumber(MonthName(DECDDT) & BRCODE & '- '& DECDDT) as Key

But adding MonthName to the key will only make the key larger without adding precision as MonthName is a lower cardinality dependent on DECDDT already in the key.

Re: Autonumber

Wed, 17 Jun 2015 12:10:05 GMT

i did like this...

BranchCal:

LOAD BRCODE,

DECDDT,

Date(DECDDT, 'DD/MM/YYYY') as DATE,

Month(DECDDT) as MONTH,

MonthName(DECDDT) as MonthYear,

Year(DECDDT) as YEAR,

DAYS,

AutoNumber(MonthName(DECDDT)&'-'&DECDDT) as Key

FROM

QVD\BranchCal.qvd

(qvd);

and in reference table like this

LOAD Distinct

MonthYear,

BRCODE,

DECDDT,

Key

Resident BranchCal;

DROP Field BRCODE from BranchCal;

DROP Field DECDDT from BranchCal;

DROP Field MonthYear from BranchCal;

is this correct.???

but i m not getting any values on MonthYear???

pls help

Re: Autonumber

Wed, 17 Jun 2015 12:56:15 GMT

any suggestions plsssss

Re: Autonumber

Thu, 18 Jun 2015 12:46:13 GMT

pls give some suggestions

Re: Autonumber

Anonymous — Thu, 18 Jun 2015 13:04:27 GMT

what are you trying to achieve? I don't understand what you are modelling. Can you upload an example of the qvw?