Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
shahamel
Creator
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

Help please

10 Replies
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

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!
shahamel
Creator
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

kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

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!
shahamel
Creator
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.

I still appriciate your efforts

Gr. Sandeep

kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

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!
shahamel
Creator
Creator
Author

I updated ths discussion, you can use my qlikview file

kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

     Try this in your expression.

     =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!
shahamel
Creator
Creator
Author

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

Sandeep

kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

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!