topic Syntax issue while loading from QVD in QlikView

Syntax issue while loading from QVD

Mon, 23 Apr 2012 12:27:55 GMT

This might be a simple issue, but am stuck.

I am trying to load from a qvd file and for the load, i need only specific records.

I am not able to give a value 'in' condition

Whats the solution ?

Syntax issue while loading from QVD

SunilChauhan — Mon, 23 Apr 2012 12:31:41 GMT

in keyword not supported in qlikview .

hence you need to assign values one by ne

like

where.........

and

(pg........VarName='CMS_29A' or pg........VarName='CMS_29B' or pg........VarName='CMS_29c')

hope this helps

Syntax issue while loading from QVD

Mon, 23 Apr 2012 12:34:55 GMT

it is

AND PG_RESPONSE_H_ABTYOU.VARNAME in ('CMS_29A','CMS_29B','CMS_29C') -- in the snapshot i have given, the CMS_29C doesnt have closing quotes..i have given this and tried..the result is the same..it shows error.

Syntax issue while loading from QVD

Mon, 23 Apr 2012 12:36:05 GMT

@Sunil

ho..thts bad.

Lemme try tht way and let u know.

Syntax issue while loading from QVD

SunilChauhan — Mon, 23 Apr 2012 12:38:24 GMT

In keyword Not supported in qlikview

so please use

and (PG_RESPONSE_H_ABTYOU.VARNAME='CMS_29A' or PG_RESPONSE_H_ABTYOU.VARNAME='CMS_29B' or

PG_RESPONSE_H_ABTYOU.VARNAME='CMS_29C')

in Place of

AND PG_RESPONSE_H_ABTYOU.VARNAME in ('CMS_29A','CMS_29B','CMS_29C')

hope this helps

Syntax issue while loading from QVD

Mon, 23 Apr 2012 12:41:53 GMT

@Sunil,

It worked.

thanks a lot..

But doesnt it looks odd that qlikview is not providing an useful functionality like IN

Re: Syntax issue while loading from QVD

Mon, 23 Apr 2012 12:54:52 GMT

Hi:

You can also use Match function, for example try this - Match(PG_RESPONSE_H_ABTYOU.VARNAME, 'CMS_29A' , 'CMS_29B', 'CMS_29C') > 0

Thanks,

Narasimha K