Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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

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.

Anonymous
Not applicable
Author

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