topic Re: IF Then Else statement .. impact with line chart and Set analysis in QlikView

IF Then Else statement .. impact with line chart and Set analysis

steeramp — Fri, 02 Oct 2020 16:17:04 GMT

I have my filtre : TypeCA='Prestations saisies', Annee=2020 and Month= Mai

I would like change the Measure for every value of TYPECA and to show the timeline max(DATE ) -11 Months --> to Max(DateSelected)

For example : for TypeCA='Prestations saisies' I want you use this expression:

(Sum({1<AnnulationDejaPayee={0}, Date={">=$(vDate_11)<=$(vMaxDate)"}, Annee= ,TypeCA=, Mois=>} Prest_Montant ) / Count(Distinct {1< Date={">=$(vDate_11)<=$(vMaxDate)"}, Annee= ,TypeCA=,Mois=>} [IDAgentSoin]) )

.. and without using the IF Statement , I have this perfect LINE : (cool)

but..... with the same filters , same SET ANALYSIS , if I use the IF THEN ELSE before the set analysis :

if(TypeCA='Prestations saisies',
(Sum({1<AnnulationDejaPayee={0}, Date={">=$(vDate_11)<=$(vMaxDate)"}, Annee= ,TypeCA=, Mois=>} Prest_Montant ) / Count(Distinct {1< Date={">=$(vDate_11)<=$(vMaxDate)"}, Annee= ,TypeCA=,Mois=>} [IDAgentSoin]) )
)

I have this result: only the value for the Mois=Mai is showed

Why ?? How the IF THEN ELSE has an impact on my SET ANALYSIS??

Re: IF Then Else statement .. impact with line chart and Set analysis

Kushal_Chawda — Fri, 02 Oct 2020 16:17:52 GMT

@steeramp try with getfieldselections

if(getfieldselections(TypeCA)='Prestations saisies' , YourExpression, OtherExpression)

Re: IF Then Else statement .. impact with line chart and Set analysis

steeramp — Fri, 02 Oct 2020 16:21:02 GMT

You are the best one !! Can you explain the differences?

Re: IF Then Else statement .. impact with line chart and Set analysis

Kushal_Chawda — Fri, 02 Oct 2020 16:28:21 GMT

@steeramp If condition tries to evaluate the expression row by row which could override the set expressions and generates inaccurate results. Whereas if you use getfieldselections it just looks at the selection made and evaluates the expression as whole considering selection you made.

Re: IF Then Else statement .. impact with line chart and Set analysis

steeramp — Fri, 02 Oct 2020 16:39:02 GMT

Great !