Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

adamjwchen
New Contributor III

data selection via excel

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?

2 Replies

Re: data selection via excel

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

Re: data selection via excel

Community Browser