Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Mahamed_Qlik
Specialist
Specialist

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
Rishabh_Chaudhary
Partner - Contributor II
Partner - Contributor II

Hi, I think you have to use the  & operator  to display your text inside double quotes. 

 

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

 

Try this once, if it solves your problem.