topic Re: Load Script in QlikView

Load Script

Wed, 29 Jul 2015 06:16:45 GMT

Hello All,

I am actually trying to load data from SQL database:

SQL SELECT AgentId,

Campaign,

Duration,

ID,

ActionLocalTime,

SessionID,

NextState

FROM "HN_Ondata".dbo.ODActions where NextState='96';

The data are loaded correctly

However, I also want to load the data where NextState is 99 so I am using the script below and it is not working:

SQL SELECT AgentId,

Campaign,

Duration,

ID,

ActionLocalTime,

SessionID,

NextState

FROM "HN_Ondata".dbo.ODActions where NextState='96' and '99';

Any idea where I am wrong please?

KR,

Hasvine

Re: Load Script

sushil353 — Wed, 29 Jul 2015 06:18:25 GMT

Hi,

SQL SELECT AgentId,

Campaign,

Duration,

ID,

ActionLocalTime,

SessionID,

NextState

FROM "HN_Ondata".dbo.ODActions where NextState in ('96','99');

Re: Load Script

pokassov — Wed, 29 Jul 2015 06:18:28 GMT

where NextState='96' or NextState='99';

Re: Load Script

Wed, 29 Jul 2015 06:19:46 GMT

Hi Try this

SQL SELECT AgentId,

Campaign,

Duration,

ID,

ActionLocalTime,

SessionID,

NextState

FROM "HN_Ondata".dbo.ODActions where NextState='96' and NextState= '99';

thanks

Manju

Re: Load Script

Wed, 29 Jul 2015 06:21:30 GMT

Thank you for the quick reply.

It is working now.

Re: Load Script

Wed, 29 Jul 2015 06:41:49 GMT

Hi Hasvine,

Try this

SQL SELECT AgentId,

Campaign,

Duration,

ID,

ActionLocalTime,

SessionID,

NextState

FROM "HN_Ondata".dbo.ODActions where NextState='96' or NextState= '99';

Re: Load Script

awhitfield — Wed, 29 Jul 2015 10:13:17 GMT

Hi Hasvine,

can you please mark the appropriate answer as CORRECT - it helps other community members.

Thanks in advance

Andy

Re: Load Script

Wed, 29 Jul 2015 11:12:36 GMT

Hi Andy,

I do not get the Correct option. I can only see helpful.

Could you please let me know where the option is so that i can change the option.

Thanks,

Hasvine

Re: Load Script

sunilkumarqv — Wed, 29 Jul 2015 11:32:52 GMT

Try this .

SQL SELECT AgentId,

Campaign,

Duration,

ID,

ActionLocalTime,

SessionID,

NextState

FROM "HN_Ondata".dbo.ODActions where NextState='96' and NextState='99';

Re: Load Script

awhitfield — Wed, 29 Jul 2015 13:26:33 GMT

Hi,

You have to open the original thread, then CORRECT will appear 🙂

Andy