topic how to load data from database with condition apply in QlikView

how to load data from database with condition apply

Sun, 21 Aug 2016 12:55:18 GMT

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 — Sun, 21 Aug 2016 23:46:06 GMT

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 — Mon, 22 Aug 2016 04:42:44 GMT

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

Thu, 08 Sep 2016 09:15:53 GMT

thanks