Quote to Text

[Mahamed_Qlik]

Hi All,

I want to display text with double quotation mark in KPI object in qliksense.
Existing :

Expecting :

Kindly suggest.

Regards,

Mahamed

[Or]

I'm not sure what the issue you're having is - there's no problem with double quotes in KPIs that I've ever noticed?

[Mahamed_Qlik]

Thanks for the response.
Company name is the dimension and displaying using some expression.

I need the expression to display double quote

[sidhiq91]

@Mahamed_Qlik I just used to below Expression in the KPI.

'"Qlik Tech"'

[Mahamed_Qlik]

Dear Sidhiq,

For hardcoded text it is working fine.
I using below expression to display company name

Aggr(If(COUNT(distinct Emp_Id)) <= 1, [Company name]), [Company name]))

[Or]

In my screen capture, the expression is displaying double quotes with no issues. Are you sure your expression actually returns a string which includes double quotes?

[Mahamed_Qlik]

My Dimension does not have double quotes included.

[Or]

That formula does not parse - too many ')' - but after fixing it, there's no problems with the KPI object.

Aggr(If(COUNT(distinct Emp_Id) <= 1, [Company name]), [Company name])

Load '"Company Name Here"' as [Company name], 1 as Emp_Id
Autogenerate(1);

[venkatesh7]

@Mahamed_Qlik  try below one, it will meet your requirement

Tab:
Load * Inline [
Company Name
Qlik Tech
Qlik
Qlik Sense
Qlik View
];

Tab2:

load

[Company Name],

'"'&[Company Name] &'"' as [Company Name Quote]

Resident Tab;

Drop Table Tab;

[Mahamed_Qlik]

I want to handle this on front end not in script.