topic Re: Qlik Sense exclude values before load data in App Development

Qlik Sense exclude values before load data

ZigaD — Thu, 06 Feb 2020 19:30:35 GMT

hi guys

you think some can help me with how i can exclude data from specific excel column, before is loaded?

for example from Column "a" i would like to prevent loading rows which include values "n1", "n2", "n3" etc.

appricate you help

Re: Qlik Sense exclude values before load data

TimvB — Thu, 06 Feb 2020 22:20:31 GMT

To filter data from a source (e.g. Excel), you should use a where clause. For example:

TableName:

Load

*
From YourExcelSource

Where not match([a], 'n1', 'n2', 'n3');

Hope it helps!

Re: Qlik Sense exclude values before load data

ZigaD — Fri, 07 Feb 2020 02:20:21 GMT

thank you for your reply its still loading so i tried below one, but it think it works only one, not multi parameters

WHERE a<>'n1'

and it created me a total new data source with "TableName_1"

can i avoid this or its normal process?

Re: Qlik Sense exclude values before load data

TimvB — Fri, 07 Feb 2020 05:41:39 GMT

WHERE a<>'n1' is indeed a valid script. If you have multiple parameters, you could use the Where Not Match() approach.

Every time you extract a table by using the statements From or Resident, a new table is created. You can then drop the table that you do not need anymore.

Re: Qlik Sense exclude values before load data

Kashyap_R — Fri, 07 Feb 2020 06:31:50 GMT

try this

Table:

Load

*
From Source

Where [a]=if(WildMatch(Trim([a]), 'n1', 'n2', 'n3')=0,[a]);

Hope this helps

Thanks

Re: Qlik Sense exclude values before load data

ZigaD — Fri, 07 Feb 2020 22:05:33 GMT

Hi Kashyap,

thank you for your help, it worked.

Appreciate your help