topic Re: Eliminating if statement in expressions in QlikView

Eliminating if statement in expressions

Tatalay2021 — Thu, 28 Jan 2021 19:36:24 GMT

Hello,

I have several expressions that use if statements, where two different set analysis calculations are performed based on field selection count. Is there a way to rewrite this expression without using an if statement?

=if(count(getfieldselections([TestFIeld1]))=0,num(FABS(SUM({1<Year={"=GetFieldSelections(Year)"},Scenario={'X'},[TestFIeld1]-={'Retail'}>}Sales))/1000000,'###,###.#'),num(FABS(SUM({1<Year={"=GetFieldSelections(Year)"},Scenario={'X'},[TestFIeld1]=$::[TestFIeld1]>}Sales))/1000000,'###,###.#'))

Thanks,

Re: Eliminating if statement in expressions

Anil_Babu_Samineni — Fri, 29 Jan 2021 19:59:05 GMT

GetFieldSelections() will not give when you use aggregate, rather you can try this way

=if(GetSelectedCount(TestField1)=0,num(FABS(SUM({1<Year={"=GetFieldSelections(Year)"},Scenario={'X'},[TestFIeld1]-={'Retail'}>}Sales))/1000000,'###,###.#'),num(FABS(SUM({1<Year={"$(=Concat(DISTINCT Chr(39) & Year & Chr(39), '',''))"},Scenario={'X'},[TestFIeld1]=$::[TestFIeld1]>}Sales))/1000000,'###,###.#'))

Re: Eliminating if statement in expressions

Tatalay2021 — Fri, 05 Feb 2021 16:38:02 GMT

Thanks for your feedback!

I should have stated this in my original post but the motivation behind this post was given what I have read elsewhere in the community about if statement impacting performance. Thus, I was trying to understand if the expression I listed is one of those situation that would need to be rewritten without including if statement. But as I think about it more perhaps that may not be applicable in this situation as I am essentially two different evaluations based on the applicable condition.

Nevertheless, I appreciate your input and will consider giving it a try in my next work.

Thanks,

Re: Eliminating if statement in expressions

Anil_Babu_Samineni — Fri, 05 Feb 2021 20:51:20 GMT

First of all, I don't see any performance issue. did you?