Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld online is next week! REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
prahlad_infy
Creator II
Creator II

How to number rows for given records in script and filter only once occuring record using set expression ?

Hi All ,

How to number rows for given records in script ?

And set expression to filter below data as its occur only once 

Panacea ABO24 1

 

Input Data :

Feature Rand_Text
Temperate Forest ABO1
Amazon Rainforest ABO10
Hawana ABO11
Grassland ABO12
Temperate Forest ABO13
Tropical ABO14
Temperate Forest ABO15
Amazon Rainforest ABO16
Grassland ABO18
Torrential Rain ABO19
Torrential Rain ABO2
Tropical ABO20
Temperate Forest ABO21
Amazon Rainforest ABO22
Panacea ABO24
Torrential Rain ABO25
Tropical ABO26
Temperate Forest ABO27
Amazon Rainforest ABO28
Hawana ABO29
Temperate Forest ABO3
Amazon Rainforest ABO4
Hawana ABO5
Grassland ABO6
Temperate Forest ABO7
Tropical ABO8
Temperate Forest ABO9

 

Output 

 

Feature Rand_Text Numbering
Amazon Rainforest ABO4 1
Amazon Rainforest ABO10 2
Amazon Rainforest ABO16 3
Amazon Rainforest ABO22 4
Amazon Rainforest ABO28 5
Grassland ABO6 1
Grassland ABO12 2
Grassland ABO18 3
Hawana ABO5 1
Hawana ABO11 2
Hawana ABO29 3
Panacea ABO24 1
Temperate Forest ABO3 1
Temperate Forest ABO9 2
Temperate Forest ABO15 3
Temperate Forest ABO21 4
Temperate Forest ABO27 5
Temperate Forest ABO1 6
Temperate Forest ABO7 7
Temperate Forest ABO13 8
Torrential Rain ABO19 1
Torrential Rain ABO25 2
Torrential Rain ABO2 3
Tropical ABO8 1
Tropical ABO14 2
Tropical ABO20 3
Tropical ABO26 4

 

Thank You all

1 Solution

Accepted Solutions
abhijitnalekar
Specialist
Specialist

Hi @prahlad_infy ,

 

Create new field in the script as

autonumber(rowno(),Feature)as Rowno,

Regards,
Abhijit
keep Qliking...

View solution in original post

1 Reply
abhijitnalekar
Specialist
Specialist

Hi @prahlad_infy ,

 

Create new field in the script as

autonumber(rowno(),Feature)as Rowno,

Regards,
Abhijit
keep Qliking...