Adding the data from excel files.

[S1m55r]

Hello,

Why Qlik team is not adding more filter condition while adding the data from excel files.

For QS Nov 2018 version i'm getting below conditions. these options are great but would be cool if we have more options like below data connector filters.

is there any other to do this besides data load editor.? I'm not familiar with data load editor

Filtering data from data connector

=

> 

>=

< 

<=

IN

BETWEEN

LIKE

IS NULL

IS NOT NULL

[jupitopino · Accepted solution]

Hi.


You can do all these options and many more from the load editor, with functions for example...
Strimg functions: https://help.qlik.com/en-us/sense/1.1/Subsystems/Hub/Content/Scripting/StringFunctions/StringFunctio...
logical functions: https://help.qlik.com/en-US/sense/1.1/Subsystems/Hub/Content/Scripting/LogicalFunctions/LogicalFunct...
Condtional functions: https://help.qlik.com/en-US/sense/1.1/Subsystems/Hub/Content/Scripting/ConditionalFunctions/Conditio...
You only just need put the required condition ("where" Condition) in the load section in the script.
Regards.