topic Re: Error while using GetFieldSelections with string values(with space) in QlikView

Error while using GetFieldSelections with string values(with space)

Techkrish — Sat, 16 Nov 2024 03:47:12 GMT

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.

Re: Error while using GetFieldSelections with string values(with space)

sunny_talwar — Tue, 23 Apr 2019 13:19:53 GMT

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.

Re: Error while using GetFieldSelections with string values(with space)

Anil_Babu_Samineni — Tue, 23 Apr 2019 13:20:03 GMT

Can you check, What this is returning in KPI?

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

Re: Error while using GetFieldSelections with string values(with space)

Techkrish — Tue, 23 Apr 2019 14:22:35 GMT

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

Re: Error while using GetFieldSelections with string values(with space)

sunny_talwar — Tue, 23 Apr 2019 14:51:06 GMT

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

Re: Error while using GetFieldSelections with string values(with space)

Techkrish — Tue, 23 Apr 2019 14:48:58 GMT

It's working fine! Thank you so much 🙂