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

[#1]

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

];

[rwunderlich]

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

[#3]

Hi rob,

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

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

[#4]

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.                                            

[#5]

'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 ....................

[#6]

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

or

'Riyadh' as Key_Filter

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

please find the attached file