Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 
					
				
		
Hi everyone.
i am struggling with writing an expression for the following.
I want to a count of all the distinct [PupilID] which meet the following criteria.
they must have a [APSScore] of more than 1. the [APSScore] is worked out by deducting [Chrono]={7} from [Chrono]={6} and by only looking at [LevelScore]='Score'.
Does this make sense?
Can anyone help please?
thanks
 its_anandrjs
		
			its_anandrjs
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hi,
You have to make expression like
Count(if( [APSScore] >1 and [Chrono] = 7 and [Chrono] = 6 and [LevelScore]='Score' , [PupilID]))
what do you mean [Chrono]={7} from [Chrono]={6}
HTH
Regards,
Anand
 
					
				
		
Hi Chrono is a field.
for example...
Student A
Chrono 7 = 25
Chrono 6 = 20
Chrono 7-Chrono 6 = 5
So as this student has a score greater than 1 i would want he/she counted. if she had a score of 0 or below then i would not want her counted.
So i need the above calculation to be in the expression
Hope that helps.
The expression you gave doesnt work as the score has not been worked out
Thanks
 its_anandrjs
		
			its_anandrjs
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hi,
So write some thing like this
Count(if( [APSScore] >1 and [Chrono7] - [Chrono6] > 0 and [LevelScore]='Score' ,[PupilID]))
Regards,
Anand
 
					
				
		
Hi thanks for replying,
Chrono is the field name, the 6 and 7 are the field values, so how would i add that to the expression. as i cant use [Chrono6] etc as chrono6 isnt a field name.
something like chrono ={6}?
 
					
				
		
or would it need to be set analyisis?
As you can see, i am new to qlikview!
 
					
				
		
Can anyone help with this?
I think i need to do something like...
if Chrono 7 - Chrono 6 >0 and LevelScore='Score' then count PupilID
I also need it to ignore selections in the field Year/Term.
but i don't know how to write this is an expression.
Many thanks
 
					
				
		
Does anyone have any ideas?
