Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Talk to Experts, a LIVE Q&A Webinar. Bring your Qlik Sense Business questions on Aug. 4th. Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

Issue with Spl characters

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

 

I1.PNG

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

I2.PNG

 

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 

I1_1.PNG

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. 

Labels (1)
5 Replies
Highlighted

Re: Issue with Spl characters

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.

 

Highlighted
Creator II
Creator II

Re: Issue with Spl characters

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

 

Highlighted

Re: Issue with Spl characters

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?
Highlighted
Creator II
Creator II

Re: Issue with Spl characters

 

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)

I1_1.PNG

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,

 

 

 

Highlighted

Re: Issue with Spl characters

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)