topic Re: IF with multiple variables in QlikView

IF with multiple variables

Anonymous — Mon, 12 Mar 2018 10:50:28 GMT

Hi All,

I have a below scenario where I am using multiple variables , am getting error like "expression is not correct"

Below are variables logic.

vBridge=[Actuals/planning scenario Code]={'B'}

vDisplayPrevisousTime=prior_period_date-----------This is direct column

vDisplayTime=current_period_date-----------This is direct column

vDimensionalityForInternalTransfer=IF(GetSelectedCount([Business Lvl 3 (Org Chart) Desc])=0,2,1)

Main expression

=IF(Dimensionality()>=$(vDimensionalityForInternalTransfer),

(Sum({$<$(vBridge), [Month End Indicator] = {'Y'} , [Report Date]={">=$(=MonthEnd(AddMonths($(vDisplayPrevisousTime),1))) <=$(=MonthEnd($(vDisplayTime)))"}>}[Bridge External New Hire Labor Cost]))

Please somebody have a look and let me know where exactly the error is, is this in logic or something I need to redesign.

Thanks & Reagrds

Savita

Re: IF with multiple variables

Digvijay_Singh — Mon, 12 Mar 2018 20:02:25 GMT

Looks like you are missing one bracket at the end for IF.

Even if it doesn't work, you may see values of your variables in separate text/image object to see if all is well with the variable values.

Re: IF with multiple variables

Anonymous — Fri, 16 Mar 2018 05:47:07 GMT

Hi DigVijay, Thank you for your response.

Am new to Qlikview, and I tried your solution but it didnt work. The brackets are fine.

The expression is too complex I don know where its breaking.

Can you please help me.

Many Thanks

Savita