Syntax issue while loading from QVD

[#1]

  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 ?

[SunilChauhan · Accepted solution]

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

[#3]

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.

[#4]

@Sunil

ho..thts bad.

Lemme try tht way and let u know.

[SunilChauhan]

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

[#6]

@Sunil,

It worked.

thanks a lot..

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

[#7]

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