Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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
Contributor III

Re: Data Load from Excel Sheet with Paste Link(QlikSense)

where clause ?

Video Link : 4112

where len(YOURFIELD) >0