topic Re: remove where condition hard coding in QlikView

remove where condition hard coding

bharatkishore — Wed, 12 Sep 2018 11:31:44 GMT

Hi All,

I have a qvd and few fields. Now when i load that qvd instead of loading whole data i need to only few system codes.

For that i am writing hard coding in where condition as below:

Where

WildMatch(SystemCode,'722006',

'722008',

'722010',

'722005',

'722011',

'722012',

'722013',

'722023',

'722025',

'722026');

Can you please tell me is there any approach to remove this had coding.

Thanks,

Bharat

Re: remove where condition hard coding

YoussefBelloum — Wed, 12 Sep 2018 11:52:45 GMT

Hi,

the script can't guess the references you want to remove, so you have to write it somewhere.

you can put it in a variable at the beginning of the script and call the variable on the WHERE, it will look cleaner maybe ?

Re: remove where condition hard coding

bharatkishore — Wed, 12 Sep 2018 11:56:48 GMT

Thanks for your reply.

Can you please tell me how to do..

Re: remove where condition hard coding

prieper — Wed, 12 Sep 2018 11:59:19 GMT

hmm,

you may put your condition into a variable:

LET myFilter = '722006, 722008';

LOAD .... FROM ....

WHERE WILDMATCH(Systemcode, $(myFilter));

The above may work easy for numbers, strings must be enclosed in apostrophs:

LET myFilter = CHR(39) & '722006' & CHR(39) & ',' & CHR(39) & '722008' & .... etc.

LET myFilter = CHR(39) & '*' & CHR(39) would not filter anything ...

Re: remove where condition hard coding

manoj217 — Wed, 12 Sep 2018 12:00:58 GMT

he is mentioned like create a variable like

set records=

WildMatch(SystemCode,'722006',

'722008',

'722010',

'722005',

'722011',

'722012',

'722013',

'722023',

'722025',

'722026');

then call the variable like

where $(records)

it is similar to your syntax but just reduce the hardcode

Re: remove where condition hard coding

YoussefBelloum — Wed, 12 Sep 2018 12:31:36 GMT

Guys already shows you examples below

Re: remove where condition hard coding

bharatkishore — Wed, 12 Sep 2018 12:47:55 GMT

Thank you so much...

Re: remove where condition hard coding

nsetty — Wed, 12 Sep 2018 14:16:48 GMT

Using joins

RequiredEntries:

Load * INLINE

[

Required

'722006'

'722008'

'722010'

'722005'

'722011'

'722012'

'722013'

'722023'

'722025'

'722026'

];

.......

Where EXISTS (SystemCode, Required)

Re: remove where condition hard coding

prieper — Thu, 13 Sep 2018 13:25:28 GMT

JOIN is a really performant tool, however you may not change it to load all, as the OP has asked for.