Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I'm getting an error "Error in set modifier ad hoc element list: ',' or ')' expected" while using the below given statement
SUM({$<Project_Name={$(=vProject_Name)} >} Forecast_Amt)
The variable "vProject_Name" has been assigned with "If(ISNULL(GetFieldSelections(Project_Name)),'*',GetFieldSelections(Project_Name))"
Sample values of Project_Name:
Clarity
BMC IT
BMC Data Hub
I'm getting error only when the project name contains space. Can someone help me to fix the issue please? Thanks.
In that case, try this
=Sum({1<Actual_Period = {2}, Month_Num = {2}, Project_Name = p(Project_Name)}>} Forecast_Amt)/1000
or this
=Sum({1<Actual_Period = {2}, Month_Num = {2}, Project_Name = $:: Project_Name}>} Forecast_Amt)/1000
Why do you even need this... why can't you just do this and let QlikView do its thing?
Sum(Forecast_Amt)
When not Project_Name is selected, it will show everything. When you select one or more Project_Name... only those will show.
Can you check, What this is returning in KPI?
If(ISNULL(GetFieldSelections(Project_Name)),'*',GetFieldSelections(Project_Name))
In that case, try this
=Sum({1<Actual_Period = {2}, Month_Num = {2}, Project_Name = p(Project_Name)}>} Forecast_Amt)/1000
or this
=Sum({1<Actual_Period = {2}, Month_Num = {2}, Project_Name = $:: Project_Name}>} Forecast_Amt)/1000
It's working fine! Thank you so much 🙂