Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
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
Highlighted
MVP & Luminary
MVP & Luminary

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

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

Highlighted
MVP & Luminary
MVP & Luminary

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

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

Highlighted
MVP & Luminary
MVP & Luminary

Re: Expression within expression in stead of a hard value

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".
Highlighted
Contributor

Re: Expression within expression in stead of a hard value

I updated ths discussion, you can use my qlikview file

Highlighted
MVP & Luminary
MVP & Luminary

Re: Expression within expression in stead of a hard value

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".
Highlighted
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

Highlighted
MVP & Luminary
MVP & Luminary

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

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