topic Expression Query in QlikView

Expression Query

Mon, 12 Nov 2012 17:58:36 GMT

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

Re: Expression Query

its_anandrjs — Mon, 12 Nov 2012 18:42:22 GMT

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

Re: Expression Query

Mon, 12 Nov 2012 18:48:34 GMT

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

Re: Expression Query

its_anandrjs — Mon, 12 Nov 2012 19:08:15 GMT

Hi,

So write some thing like this

Count(if( [APSScore] >1 and [Chrono7] - [Chrono6] > 0 and [LevelScore]='Score' ,[PupilID]))

Regards,

Anand

Re: Expression Query

Mon, 12 Nov 2012 19:57:20 GMT

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}?

Re: Expression Query

Mon, 12 Nov 2012 19:58:05 GMT

or would it need to be set analyisis?

As you can see, i am new to qlikview!

Re: Expression Query

Mon, 12 Nov 2012 20:52:53 GMT

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

Re: Expression Query

Tue, 13 Nov 2012 08:41:27 GMT

Does anyone have any ideas?