datamodel

maniram23 — Sun, 28 Jun 2015 07:16:02 GMT

Hi experts,

what are the types of counter function? give am an example of each and every one.

Re: datamodel

marcus_sommer — Sun, 28 Jun 2015 07:22:04 GMT

See Counters in the Load

- Marcus

Re: datamodel

fkeuroglian — Sun, 28 Jun 2015 15:09:53 GMT

See this, hope help

Fernando

Aggregation Functions in QlikView

Re: datamodel

Siva_Sankar — Mon, 29 Jun 2015 08:52:21 GMT

From Help file:

Counter Functions

These functions do not have any parameters. The parentheses are however still required.

RecNo( )

Returns an integer for the number of the currently read row of the source data table. The first record is number 1.

RowNo( )

Returns an integer for the position of the current row in the resulting QlikView internal table. In contrast to RecNo( ), which counts the records in the raw data table, the RowNo( ) function does not count records that are excluded by where clauses and is not reset when a raw data table is concatenated to another. The first row is number 1.

Note!
If you use preceding load, that is, a number of stacked Load statements reading from the same table, you can only use RowNo( ) in the top Load statement. If you use RowNo( ) in subsequent preceding Load statements, 0 is returned.

Examples:

Raw data tables:

Tab1.csv
A	B
1	aa
2	cc
3	ee

Tab2.csv
A	B
5	xx
4	yy
6	zz

QVTab:

Load *, RecNo( ), RowNo( ) from Tab1.csv where A<>2;

Load *, RecNo( ), RowNo( ) from Tab2.csv where A<>5;

The resulting QlikView internal table:

QVTab
A	B	RecNo( )	RowNo( )
1	aa	1	1
3	ee	3	2
4	yy	2	3
6	zz	3	4

IterNo( )

This function is only meaningful if used together with a while clause, see Load. IterNo( ) returns an integer indicating for which time one single record is evaluated in a load statement with a while clause. The first iteration has number 1.

autonumber(expression[ , AutoID])

Returns a unique integer value for each distinct evaluated value of expression encountered during the script execution. This function can be used e.g. for creating a compact memory representation of a complex key.

In order to create multiple counter instances if the autonumber function is used on different keys within the script, an optional parameter AutoID can be used for naming each counter.

Examples:

autonumber( Region&Year&Month )

autonumber( Region&Year&Month, 'Ctr1' )

autonumberhash128(expression {, expression})

Calculates a 128-bit hash of the combined input expression values and the returns a unique integer value for each distinct hash value encountered during the script execution. This function can be used e.g. for creating a compact memory representation of a complex key.

Example:

autonumberhash128 ( Region, Year, Month )

autonumberhash256(expression {, expression})

Calculates a 256-bit hash of the combined input expression values and returns a unique integer value for each distinct hash value encountered during the script execution. This function can be used e.g. for creating a compact memory representation of a complex key. This function is only available as a script function.

Example:

Autonumberhash256 ( Region, Year, Month )

fieldvaluecount(fieldname)

Returns the number of distinct values in a field. Fieldname must be given as a string (e.g. a quoted literal).

Example:

let x = fieldvaluecount('Alfa');

topic datamodel in QlikView

datamodel

Re: datamodel

Re: datamodel

Re: datamodel

Counter Functions