topic Re: AutoNumber(recno(),Ref) as Count how it is calculating pls explain me in QlikView

AutoNumber(recno(),Ref) as Count how it is calculating pls explain me

Thu, 10 Jul 2014 16:50:37 GMT

AutoNumber(recno(),Ref) as Count how it is calcilating pls

TEST:

LOAD * INLINE

[

Ref, Amount, Date

ABC, 100, 01/01/2012

ABC, 100, 01/01/2013

ABC, 150, 01/01/2014

BCD, 200, 15/01/2013

BCD, 225, 15/01/2014

CDE, 300, 20/01/2014

DEF, 300, 06/04/2012

DEF, 275, 06/04/2013

EFG, 200, 08/08/2013

FGH, 225, 10/12/2013

];

Re: AutoNumber(recno(),Ref) as Count how it is calculating pls explain me

rwunderlich — Thu, 10 Jul 2014 17:19:29 GMT

AutoNumber() is a lookup function that returns a sequence number for each unique value it sees. The second parm allows for maintaining individual counter sets.

RecNo() is a unique number for every row,

Ref will be common to several rows.

The AutoNumber(recno(), Ref) will assign a 1,2,3,... sequence number within each Ref value.

-Rob

Re: AutoNumber(recno(),Ref) as Count how it is calculating pls explain me

Thu, 10 Jul 2014 18:01:03 GMT

Hi rob,

pls tell me how to create flags and what is the use can u give small example

pls pls .....................................

Re: AutoNumber(recno(),Ref) as Count how it is calculating pls explain me

Thu, 10 Jul 2014 19:21:03 GMT

Hi,

Assume you are loading customer Table from 3 different DB viz DB1 , DB2, DB3 which contains Cust_ID and Cust_Name.

when you load them in qlikview ,due to auto concatenate it will treated as one table.

Question :

Who can I read only data from DB2 ?

In order to resolve the issue Flag concept comes into picture as scripted below.

DB1:

LOAD Cust_ID,

Cust_Name,

'Riyadh' as flag

FROM

(ooxml, embedded labels, table is Riyadh);

DB2:

LOAD Cust_ID,

Cust_Name,

'Makkah' as flag

FROM

(ooxml, embedded labels, table is Makkah);

DB3:

LOAD Cust_ID,

Cust_Name,

'Madinah' as flag

FROM

(ooxml, embedded labels, table is Madinah);

once you loaded the above script . drop the flag field as filter.

Re: AutoNumber(recno(),Ref) as Count how it is calculating pls explain me

Fri, 11 Jul 2014 02:30:47 GMT

'Riyadh' as flag

'Madinah' as flag

'Makkah' as flag

where this fields are avaliable or here we are creating ? riyadh,madinah and makkah?

how to drop the FLAG field as a filter

pls ....................

Re: AutoNumber(recno(),Ref) as Count how it is calculating pls explain me

Mon, 14 Jul 2014 09:35:53 GMT

Hi,

1. This flags are not from the source , you can create them in the script as I did it ,

you can use numerical char or whatever you like.

ex.

1 as Flag

'F1' as Flag

'Riyadh' as Key_Filter

2. After reload, you will find Flag as Dimension drop it as listbox.

please find the attached file