Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
savi_khyadi
New Contributor

IF with multiple variables

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

2 Replies
Digvijay_Singh
Honored Contributor III

Re: IF with multiple variables

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.

savi_khyadi
New Contributor

Re: IF with multiple variables

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

Community Browser