Issue with Spl characters

[satishqlik]

Hi Team,

I've an issue with calling string(which has special character)

I have one field name called KPI Name

Case1: In this situation its working fine KPI Name which has no spl characters

Case 2: Selections of KPI Name which has Spl characters and not working as expected.

In line chart my dimension and expression is looks like,

Dim1: Periodstring

Dim2: Brand

Exp:
Avg({<KPI Name={$(=$(selected_Cal_KPI_temp1))},RollingMonth=>}Value/100)

Also find below variables those I have created.

In first chart for to enable selections with KPI Name 

selected_Cal_KPI_temp: empty

selected_Cal_KPI_temp1:

Chr(39)&selected_Cal_KPI_temp&Chr(39)  //This variable I've used in expression in Line chart trend.

Can someone help me on this(Case2).

Any suggestions will be appreciated.

Thanks. 

[sunny_talwar]

Can you try this

Avg({<KPI Name={"$(=$(selected_Cal_KPI_temp1))"}, RollingMonth>} Value/100)

Also, I am not sure what is this getting used for?

---

@satishqlik wrote:

selected_Cal_KPI_temp: empty

selected_Cal_KPI_temp1:

Chr(39)&selected_Cal_KPI_temp&Chr(39)  //This variable I've used in expression in Line chart trend.

[satishqlik]

Thanks for the response.

Same I've used as you suggested.But still no luck.

Those variables which I've created, to give the selections from the 1st component.

selected_Cal_KPI_temp: to set default KPI Name when we open the dashboard(for now I haven't given any default KPI Name if we make any selections from component1 then we will be able to see KPI Name aggregated results in line chart)

and

selected_Cal_KPI_temp1: This  is I've used in Expression in Line chart.

Hope, this clear.

Can you please suggest any other approaches.... 

[sunny_talwar]

So, your link chart expression is this?
Chr(39)&selected_Cal_KPI_temp&Chr(39)

The name of the KPI is your expression? I am not sure I understand this... would you be able to share a sample?

[satishqlik]

Thanks for the quick response.

You wrote:

"

So, your link chart expression is this?
Chr(39)&selected_Cal_KPI_temp&Chr(39)

"

-No that is variable.

Sorry.I can't share share my sample as I'm working on actual data.

The Expression is in Component2(Line chart)

Avg({<KPI Name={$(=$(selected_Cal_KPI_temp1))},RollingMonth=>}Value/100)

This expression is not working for KPI Name which has Special characters.

and variables

selected_Cal_KPI_temp:           

//This variable I've used in component1 to give the KPI Name selections.(you can see here)

selected_Cal_KPI_temp1:  Chr(39)&selected_Cal_KPI_temp&Chr(39)

 //This variable I've used in expression for component2(Line chart)

Also I have replaced with below expression as you suggested.But no luck 

Avg({<KPI Name={"$(=$(selected_Cal_KPI_temp1))"},RollingMonth=>}Value/100)

That would be great if I can have  any other approaches.

Thanks,

[sunny_talwar]

I am not understanding this 100%, but can you try this (Used selected_Cal_KPI_temp instead of selected_Cal_KPI_temp1

Avg({<KPI Name = {"$(=$(selected_Cal_KPI_temp))"}, RollingMonth>} Value/100)