Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

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


(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


2 Replies
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.

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


Community Browser