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
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Data Load from Excel Sheet with Paste Link(QlikSense)

Hi All,

I am trying to load data from my excel sheet into Qlik. This sheet is linked and have linked formulas to be updated in futures. Qlik loads all the empty cells as well since it contains formulas. How can I load only data not the records containing only link formulas. Thanks

1 Reply
mikaelsc
Specialist
Specialist

where clause ?

Video Link : 4112

where len(YOURFIELD) >0