Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ?
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
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
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.
@Sunil
ho..thts bad.
Lemme try tht way and let u know.
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
@Sunil,
It worked.
thanks a lot..
But doesnt it looks odd that qlikview is not providing an useful functionality like IN
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