Announcements
cancel
Showing results for
Did you mean:
Creator

## 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

10 Replies

Hi,

Try this.

num

(

sum({<

TaakSchaalscore.tss_taa_score = {"40"} >}

TaakSchaalscore.tss_schaalscore)

,'#.##0')

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
Creator
Author

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

Hi,

Try This.

num

(

sum({<

TaakSchaalscore.tss_taa_score =

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

>}

TaakSchaalscore.tss_schaalscore)

,'#.##0')

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
Creator
Author

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.

Gr. Sandeep

Dear Sandeep,

Kindly post your application to know the problem.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
Creator
Author

I updated ths discussion, you can use my qlikview file

Hi,

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

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
Creator
Author

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

Sandeep

Hi,

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

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
Community Browser