Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

kailashkotak91
New Contributor II

Excluding some values while loading

Hello Everyone,

I am loading the data from SQL server. Can someone help me to exclude some data when I load in QlikView.

I have more than 5000 values in a column and i want to exclude 35 of those values when I load data. Can someone tell me a better way than where clause ?

Thanks in advance

Regards,
Kailash Kotak.

1 Reply
MVP
MVP

Re: Excluding some values while loading

It seems to me a good solution to exclude the values using a sq serverl where clause (not in (....))

Why you don't like it?