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: 
Not applicable

Issue with variable parameters and complex expression.

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

0 Replies