Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 kurakuaa
		
			kurakuaa
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hi All,
I am facing some issue in showing all duplicates in list box. So I need some help for my below input.
| ID | Name | 
|---|---|
| 1 | A | 
| 2 | A | 
| 3 | A | 
| 4 | A | 
| 5 | B | 
| 6 | C | 
| 7 | D | 
| 8 | D | 
| 9 | E | 
In the above input ID I will not be using anymore in qlikview. Now I need to show all the Name column vales in List box without distincting. So if I get below output with help of row no then I will be writing logic based on row no for incrementing spaces in Name column for each name. So I need below as output
| ID | Name | Row no | 
|---|---|---|
| 1 | A | 1 | 
| 2 | A | 2 | 
| 3 | A | 3 | 
| 4 | A | 4 | 
| 5 | B | 1 | 
| 6 | C | 1 | 
| 7 | D | 1 | 
| 8 | D | 2 | 
| 9 | E | 1 | 
Many thanks in advance
Thanks,
Avinash jagan bpn qlik_dev_new
 sunny_talwar
		
			sunny_talwar
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		 sunny_talwar
		
			sunny_talwar
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		You can create RowNo like this
AutoNumber(RowNo(), Name) as [Row no]
 kurakuaa
		
			kurakuaa
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hi Sunny,
Many thanks for your reply.
Right now I am hardcoding like if row number is 1 then Name&' ', if row number is 2 the Name&' '(two spaces) like that. So is there any dynamically incrementing the spaces based on row number like that.
I need your help on this dynamically incrementing the spaces.
Thanks in advance.
Thanks,
Avinash kuraku
 sunny_talwar
		
			sunny_talwar
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Try this
Table:
LOAD *,
Name & Repeat(' ', AutoNumber(RowNo(), Name)) as New_Name;
LOAD * INLINE [
ID, Name
1, A
2, A
3, A
4, A
5, B
6, C
7, D
8, D
9, E
];
