Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
mahamedfaijan
Creator II
Creator II

Quote to Text

Hi All,

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

mahamedfaijan_0-1659858249480.png


Expecting :

mahamedfaijan_1-1659858275226.png

 

Kindly suggest.

Regards,

Mahamed

 

 

Labels (1)
10 Replies
Or
Champion
Champion

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?

Or_2-1659862124599.png

 

 

 

mahamedfaijan
Creator II
Creator II
Author

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

I need the expression to display double quote

sidhiq91
Specialist
Specialist

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

'"Qlik Tech"'

sidhiq91_0-1659862441276.png

 

mahamedfaijan
Creator II
Creator II
Author

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

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?

mahamedfaijan
Creator II
Creator II
Author

My Dimension does not have double quotes included.

Or
Champion
Champion

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);

Or_0-1659863034250.png

 

venkatesh7
Partner - Contributor
Partner - Contributor

@mahamedfaijan  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;

mahamedfaijan
Creator II
Creator II
Author

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