data selection via excel

[adamjwchen]

Hi,

Is there anyway to allow Sense users to select data via their own excel file?

For example, user wants to select 1000 specific SKUs, they have SKU list in Excel already, is there way to select SKUs which match in the given Excel?

[marcus_sommer]

You could create a search-string for your list in the format of: (value1|value2|....). Within QlikView this approach is limited to a max. number of chars (I don't know actually how many are accepted) but maybe this is different in Qlik Sense.

Another possibility might be the use of an extension like: https://www.akquinet.de/en/sense-excel/index.jsp.

- Marcus

[OmarBenSalem]

yes , please use where exists :

refer to this:

http://help.qlik.com/fr-FR/qlikview/12.1/Subsystems/Client/Content/Scripting/InterRecordFunctions/Ex...