2 Replies Latest reply: Jan 4, 2018 8:33 AM by omar bensalem

data selection via excel

Adam Chen Jan 4, 2018 12:15 AM

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?

Re: data selection via excel

Marcus Sommer Jan 4, 2018 8:11 AM (in response to Adam Chen)

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
Like Show 0 Likes (0)

Actions
Re: data selection via excel

omar bensalem Jan 4, 2018 8:33 AM (in response to Adam Chen)

yes , please use where exists :

refer to this:
http://help.qlik.com/fr-FR/qlikview/12.1/Subsystems/Client/Content/Scripting/InterRecordFunctions/Exists.htm
Like Show 0 Likes (0)

Actions

Go to original post