10 Replies Latest reply: Jul 31, 2013 7:17 AM by Sandeep Hamelink

# Expression within expression in stead of a hard value

Dear QV-Users

I have this expression

num

(

sum({<

TaakSchaalscore.tss_taa_score =

{
"= TaakSchaalscore.tss_taa_score = 40"}

>}

TaakSchaalscore.tss_schaalscore)

,'#.##0')

It's result is 52

I would like to use this expression

num

(

sum({<

TaakSchaalscore.tss_taa_score =

{
"= TaakSchaalscore.tss_taa_score = aggr(max(toetsResultaat.score),Inspectiesleutel)"}

>}

TaakSchaalscore.tss_schaalscore)

,'#.##0')

This expression gives also 52 as result, BUT you have to make sure you selected TaakSchaalscore.tss_taa_score = 40

aggr(max(toetsResultaat.score),Inspectiesleutel) <-- this expression gives 40 as result in this case.

as you can see i tried to use it within the expression above. It works, but i would like to make it work WITHOUT making a

selection in TaakSchaalscore.tss_taa_score

• ###### Re: Expression within expression in stead of a hard value

Hi,

Try this.

num

(

sum({<

TaakSchaalscore.tss_taa_score = {"40"} >}

TaakSchaalscore.tss_schaalscore)

,'#.##0')

Regards,

Kaushik Solanki

• ###### Re: Expression within expression in stead of a hard value

Hi,

Sorry, but i would lke to use

aggr(max(toetsResultaat.score),Inspectiesleutel)

because 40 is a check, there are other results then 40 which i can get, but i use 40 as a control number.

if

i can use aggr(max(toetsResultaat.score),Inspectiesleutel) withiout making a selection and still be abel to get 52 a a result ,then it words.

another example is

aggr(max(toetsResultaat.score),Inspectiesleutel) = 258

and

num

(

sum({<

TaakSchaalscore.tss_taa_score =

{
"= TaakSchaalscore.tss_taa_score = aggr(max(toetsResultaat.score),Inspectiesleutel)"}

>}

TaakSchaalscore.tss_schaalscore)

,'#.##0')

should give 85 WITHOUT making a selection

Regards,

Sandeep

• ###### Re: Expression within expression in stead of a hard value

Hi,

Try This.

num

(

sum({<

TaakSchaalscore.tss_taa_score =

{'=aggr(max(toetsResultaat.score),Inspectiesleutel)'}

>}

TaakSchaalscore.tss_schaalscore)

,'#.##0')

Regards,

Kaushik Solanki

• ###### Re: Expression within expression in stead of a hard value

I would lke to say, thank you, but unfortunately i still have to make a selection in TaakSchaalscore.tss_taa_score in order to make your expression work.

I still appriciate your efforts

Gr. Sandeep

• ###### Re: Expression within expression in stead of a hard value

Dear Sandeep,

Kindly post your application to know the problem.

Regards,

Kaushik Solanki

• ###### Re: Expression within expression in stead of a hard value

I updated ths discussion, you can use my qlikview file

• ###### Re: Expression within expression in stead of a hard value

Hi,

Try this in your expression.

=Max(aggr(\$(vCITOTEST),Inspectiesleutel))

Regards,

Kaushik Solanki

• ###### Re: Expression within expression in stead of a hard value

I like your enthousiasm for solving this problem, still it is not correct.

Sandeep

• ###### Re: Expression within expression in stead of a hard value

Hi,

Tell me what is your expected output and on which tab of your application.

Regards,

Kaushik Solanki

• ###### Re: Expression within expression in stead of a hard value

I would like to have a column which gives

the score for each inspectiesleutel

next to this column i like to have

the 'schaal' which corresponds with the score.

It is like this.

Each inspectiesleutel has one score (toetsresultaat.score)

Each taakschaalscore.tss_taa_score has one taakschaalscore.tss_schaalscore when combined with one

speciic

toetsondrdeel.dodToetsCode