Multibox Expression for "Like" function in sql

[#1]

In sql we can use Like follow by % to filter out records... i wonder how can i achieve it in qlikview multi box. as my record consist of

For example,

E12,E13,E14,A12,A13,C12,C13

i want to get only phase start with E in my multibox. thx

[#2]

Anand,

what is the different between your method with hth/gg's method? which one resolve less CPU resources in high performance? as my sql database initially 14,000,00 records? if every time reload i wondering how to speed it up... for every reload time

Thanks.

[its_anandrjs]

Hi,

Difference is that when ever you use any resident tables it is faster than any other table loads because it is virtual and loaded fastly as compare to other and it is available in the application it self no need to take from any other. Thats why it is help ful and on this a calculated field  are generated.

If you have any table just load data from there whether it is Query or Sql Table and create a resident load.

HTH

Best Rgds

Anand

[gandalfgray]

Hi anand

I would not agree on your statement about resident loads, (at least not in v9)

see this thread (which btw is an excellent thread to read for any QV developer to create better applications).

And besides my solution does a preceeding load directly on the sql select,

and not two loads from a sql source,

so after my solution there will only be one table created, but with anands solution there will be two (unless you later drop the first of course)

Anyway I think Jeffrey should try both solutions with his actual data, and see which performs best

regards

/gg

[its_anandrjs]

Hi,

Yes you right agreed but my concern is about any calculation related more i think i not mention there if you have any calculations or more complex expression on that the resident is more easy way. Yes the preceeding load directly on sql is correct. But if we need calculation on that basis is easy any way you got correct way of that.

Best Rgds

Anand