Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
savi_khyadi
Contributor
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
Master III
Master III

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