Error while using GetFieldSelections with string values(with space)

[Techkrish]

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.

[sunny_talwar]

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.

[Anil_Babu_Samineni]

Can you check, What this is returning in KPI?

If(ISNULL(GetFieldSelections(Project_Name)),'*',GetFieldSelections(Project_Name))

[Techkrish]

Please see this one. I'm using "1" in the below statement. In this, if I don't specify a specific project, it'll give me the sum of all the projects. Any solution on this? Thanks.

=sum({1<Actual_Period = {2}, Month_Num = {2}, Project_Name={$(=vProject_Name)}>} Forecast_Amt)/1000

[sunny_talwar · Accepted solution]

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

[Techkrish]

It's working fine! Thank you so much 🙂