Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 ali_hijazi
		
			ali_hijazi
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hello
I want to use input fields
my script contains the following:
inputfield THRESHOLD;
TABLE:
LOAD * INLINE [
QUALITY_LEVEL, JOB_ID, THRESHOLD
QL1, X, 2
QL2, X, 3
];
qlikview is giving an error message saying duplicate key detected for input fields
Please advise
 
					
				
		
What version are you using? And is there any other code you have present?
I just ran that exact code with no issues, maybe you have the THRESHOLD field elsewhere in your application too?
Joe
 
					
				
		
Rename your THRESHOLD field and try . If problem still persist .. need to see the code.
Thanks
BKC
 ali_hijazi
		
			ali_hijazi
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		I get the following always:

i work on version SR8
 
					
				
		
 sasiparupudi1
		
			sasiparupudi1
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		try
TABLE:
LOAD * INLINE [
QUALITY_LEVEL, JOB_ID, THRESHOLD
QL1, X, 2
QL2, Y, 3
];
and see if you get the error?
 rubenmarin
		
			rubenmarin
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hi Ali, just that piece of code should work.
That message means there will be another table loading more rows where QUALITY_LEVEL and JOB_ID has the same values. Each row for the input field must have a unique combination of key values.
In example, this will fail:
inputfield THRESHOLD;
TABLE:
LOAD * INLINE [
QUALITY_LEVEL, JOB_ID, THRESHOLD
QL1, X, 2
QL2, X, 3
QL2, X, 4
];
The combination QL2, X should have only one row.
 
					
				
		
 sasiparupudi1
		
			sasiparupudi1
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		or try this
LOAD RowNo() AS Key,QUALITY_LEVEL,JOB_ID, THRESHOLD
INLINE [
QUALITY_LEVEL, JOB_ID, THRESHOLD
QL1, X, 2
QL2, X, 3
];
 
					
				
		
 sasiparupudi1
		
			sasiparupudi1
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		May be this post can help you
 
					
				
		
 sasiparupudi1
		
			sasiparupudi1
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hi
Have you managed to solve your problem
?
Sasi
 qlikviewwizard
		
			qlikviewwizard
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hi Can you upload your sample application? Thank you.
