Qlik Community

Ask a Question

New to Qlik Sense

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

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
mahitham
Creator II
Creator II

left function help

Hi,

Can any one  please help me to exclude .xlsx from the below field called Filename.

Filename
abcd.xlsx
abcdefghj.xlsx
abcdefghijk.xlsx
 
1 Solution

Accepted Solutions
kumarkp412
Creator II
Creator II

Hi,

Use the subfeild function to get before .xlsx.

ex: subfeild(string,'.',1) as string

 

Thanks

kumar kvp

View solution in original post

1 Reply
kumarkp412
Creator II
Creator II

Hi,

Use the subfeild function to get before .xlsx.

ex: subfeild(string,'.',1) as string

 

Thanks

kumar kvp

View solution in original post