If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
Hi All,
I want to display text with double quotation mark in KPI object in qliksense.
Existing :
Expecting :
Kindly suggest.
Regards,
Mahamed
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?
Thanks for the response.
Company name is the dimension and displaying using some expression.
I need the expression to display double quote
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]))
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?
My Dimension does not have double quotes included.
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);
@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;
I want to handle this on front end not in script.