Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
shahamel
Contributor

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

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

shahamel
Contributor

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

shahamel
Contributor

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

shahamel
Contributor

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

shahamel
Contributor

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