Issue with variable parameters and complex expression.

Wed, 04 Mar 2015 19:00:29 GMT

Recently did a server move for application -- old one was last saved in version 10. The below, as well as several other similar expressions are coming up as $0. I didn't create the original - trying to make sense of it now to troubleshoot. Seems that SecondaryDimensionality was used so that when you collapse year, you see only end of year on hand.

Also note that vCalendar is being used because there are multiple calendars.

Variable:

eOH_Units = sum({<$($1)>} [On Hand Units] $($2))

Expression in pivot table (attached):

IF(SecondaryDimensionality() = 2 ,$(eOH_Units),

IF(SecondaryDimensionality() = 1 AND (GetSelectedCount([Week Ending Date]) <> 0 OR GetSelectedCount([$(=vCalendar& ' WeekNum')]) <> 0 OR GetSelectedCount([$(=vCalendar&' Month Name Short')]) <> 0 OR GetSelectedCount([$(=vCalendar&' Season')]) OR GetSelectedCount([$(=vCalendar&' QT')]) <> 0) , $(eOH_Units(vMaxWeekNumber))

, $(eOH_Units(,='*[' & vCalendar &' EOY_Flag]')))

)

Please take a look and offer suggestions. First attachment is the correct (old) app and the second is the one with issues.

Thanks!!!

topic Issue with variable parameters and complex expression. in QlikView

Issue with variable parameters and complex expression.