how to load data from database with condition apply

[#1]

HI,

please help me in loading the data from database which should restrict rows based on my condition.

ex: select * from ot_sales where sm_code='E2783';  (this is an sql stmt. how to apply this in qlikview while loading)

Regards

Vignesh

[sunny_talwar · Accepted solution]

I think you can continue using your SQL in QlikView as well:

TableName:

SQL SELECT *

FROM ot_sales

WHERE sm_code = 'E2783';

But if for some reason you want to apply this in QlikView, you can do this

TableName:

LOAD *

Where sm_code = 'E2783';

SQL SELECT *

FROM ot_sales;

[vikasmahajan]

Hi,

I think this conditions can be handled in qlikview set analysis load all data into qlikview instead of conditions

apply set analysis for expressions.

sm_code={'E2783'}

Hope this helps you

Vikas

[#4]

thanks