Qlik Community

New to Qlik Sense

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

Tell us which business and trade publications you read most regularly: RESPOND NOW
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

where clause ?

Video Link : 4112

where len(YOURFIELD) >0