Qlik Community

New to Qlik Sense

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

Announcements
Tell us which business and trade publications you read most regularly: RESPOND NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

please tell me the below answers

1)  ASCII and character values to display in table

2) this is variable my string function

let vrepeat=Repeat('*#',4);

output  : *#*#*#*#  display..okay

let vrepeat=Repeat('&*#',3);

i want output is & *#*#*# like that ..

3)Remove the character(#) in the name field

4) this my table

firstname          lastname

rajeev               sunkara

i want to display like  rajeevsunkara

2 Replies
ariel_klien
Specialist
Specialist

1) I didn't understood  what you meant ... for ASCII numbers you can use chr(#)

2)  let vrepeat= '& ' & Repeat('*#',3);

3) PurgeChar(fieldName,'#')

4) firstname&lastname as Full_name   



BR


Ariel  

rnt
Employee
Employee

1) Do you want a table with all ASCII characters and their respective number?

Characters:

Load Chr(RecNo()+Ord('A')-1) as Alpha, Ord('A') - 1 + RecNo() as Num autogenerate 26;

This will create a table from A - Z (upper case) and respective numbers (65-90)