Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
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

Hi,

     Try this.

num

(

sum({<

TaakSchaalscore.tss_taa_score = {"40"} >}

   TaakSchaalscore.tss_schaalscore)

,'#.##0')

Regards,

Kaushik Solanki

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".
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

Hi,

     Try This.

num

(

sum({<

TaakSchaalscore.tss_taa_score =

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

    >}

   TaakSchaalscore.tss_schaalscore)

,'#.##0')

Regards,

Kaushik Solanki

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".
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

Dear Sandeep,

     Kindly post your application to know the problem.

Regards,

Kaushik Solanki

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".
shahamel
Creator
Creator
Author

I updated ths discussion, you can use my qlikview file

kaushiknsolanki

Hi,

     Try this in your expression.

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

Regards,

Kaushik Solanki

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".
shahamel
Creator
Creator
Author

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

Sandeep

kaushiknsolanki

Hi,

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

Regards,

Kaushik Solanki

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".