Skip to main content
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